Can you nest a CONCATENATE within a VLOOKUP

[Lance]

use the INDIRECT fuction.

eg
=VLOOKUP(D16,INDIRECT(D15&"A1:A9"),1,0)
where d15 = the path and "a1:a9" = the table

LAnce

 

[Andi]

I tried what you had suggested and received a #REF error.
I tried two different ways.

This:
=VLOOKUP(C1,INDIRECT("c:\my
temp\"&A2&".xls"&"A1:B2"),2,FALSE)

and This:
=VLOOKUP(C1,INDIRECT(B2&"A1:B2"),2,FALSE)

I receive the same error both ways.

What am I missing?