VLOOKUP within VLOOKUP??

[Rich18144]

Ok, heres the problem, I have to make excel call a table_range for use within a VLOOKUP formula, but to discover the range it requiers, it must VLOOKUP another table to discover the range it requires.

Now, doing this (at least in theory) should be this:

(VLOOKUP(P3,(VLOOKUP(E3,Lookups!D2:E17,2),2))

Correct?? However, it wont seem to work, Any ideas people?

Rich18144

[Ron Coderre]

As long as the second VLOOKUP returns something that looks like a range or range name to Excel (Like "A1:C40" or MyDataRange), I'm guessing that this might work for you . . .

=VLOOKUP(P3,INDIRECT(VLOOKUP(E3,Lookups!D2:E17,2)),2)

Does that help?

Ron

[Rich18144]

Looks So Ron! I'll mess around with it for a bit, see if i can get it to work for the whole table!!

Cheers!