Lookup function

  • Thread starter Thread starter Trip Levert
  • Start date Start date
T

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
 
Hi
not much detail but you may use something like
=VLOOKUP(A1,INDIRECT("'" & cell_with_sheetname & "'!A1:B1000"),2,0)
 
Back
Top