vlookup question using values within a cell

**Chrisnelsonusa** · 01-02-2009, 05:02 PM

I have an excel sheet that I am attaching to this question.

I am trying to find the value in a named range (the named range is listed in cell H1) and the column I am looking for is named in cell L1. My first attempt at the vlookup formula is as follows:

=VLOOKUP(I2,VALUE(H2),VALUE(L2),FALSE)

**Chrisnelsonusa** · 01-02-2009, 05:09 PM

I want a vlookup of :=VLOOKUP(I2,H2,L2,FALSE)

What I know works is:
=VLOOKUP(I2,EWR,L2,FALSE) - but I have 97 different ranges and I did not want to put them in each equation.

**shg** · 01-02-2009, 05:27 PM

Your spreadsheet doesn't give much of a hint of what you're trying to do; There's no VLOOKUP formula and no named ranges.

Maybe =VLOOKUP(I2, INDIRECT(H2), L2, FALSE)

**Chrisnelsonusa** · 01-02-2009, 05:53 PM

Thanks for the reply. I know that I was poor in describing what I needed, but it turned out to be the "Indirect" command.

**VBA Noob** · 01-02-2009, 05:54 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save