Lookup function

[Trip Levert]

I am using Excel 2002. Is there a way to use a v or h
lookup function that first looks for the sheet name and
then goes to look_up value, range, etc..?

Thanks
Trip

 

[Frank Kabel]

Hi
not much detail but you may use something like
=VLOOKUP(A1,INDIRECT("'" & cell_with_sheetname & "'!A1:B1000"),2,0)