Vlookup

A

aj

Hi- I am using vlookup where the lookup table is in another file, I
have the file name in a cell of the sheet, please let me know how to
refer to the file name and range name in the vlookup function by using
the cell address that contains the file name.
 
M

Max

Try something like:
=VLOOKUP(A1,INDIRECT("'"&C1&"'!"&C2),2,0)
where C1 houses the lookup table's filename, C2 houses the range name
Note that INDIRECT requires the lookup table's file be open, otherwise
you'll get #REF! error
 
Top