Re-post lookup function

[Trip]

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

Thanks Frank for: =VLOOKUP(A1,INDIRECT("'" &
cell_with_sheetname & "'!A1:B1000"),2,0)
But this formula works within a workbook. I would like it
to reference another workbook. Is this possible?

Trip

 

[Frank Kabel]

Hi
is the other workbook open? If yes try
=VLOOKUP(A1,INDIRECT("'[your_workbook_name.xls]" & cell_with_sheetname
& "'!A1:B1000"),2,0)
This won't work if the other workbook is closed!

P.S.: you should try to stay in the same thread for follow up questions

 

[Trip]

Thanks Frank!