Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2004
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Lookup and cell Refrence (Excel 2000)

    I'm trying to place a cell reference in the Lookup function. Here is the information.
    Cell H2 = 24M
    Cell I2 = =CONCATENATE("'",H2,"'","!$F$4:$F$25")
    Lookup function is =LOOKUP(P2,I12,'24M'!$H$4:$H$25)
    I'm trying to obtain the Lookup formulat = Lookup(P2,'24M!$F$4:$F$25,'24M'!$H$4:$H$25)
    The lookup vector changes depending on what value is in cell H2. In trying to substitue a cell reference in the lookup functions it's adding quotes to the value and therefore it won't work. How can I substitue a cell reference and obtain the exact value from that cell>

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Lookup and cell Refrence (Excel 2000)

    Try =LOOKUP(P2,INDIRECT(I2),'24M'!$H$4:$H$25)

    The INDIRECT function will change a text string into a cell reference.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •