View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lee Harris Lee Harris is offline
external usenet poster
 
Posts: 8
Default VLOOKUP using cell reference

Can you set the 2nd parameter of VLOOKUP so that it looks at the tab
according to the cell

e.g

VLOOKUP(A1,STRING!A:C,3,0)

where STRING is what I want to be the contents of some other cell, so that I
can change which tab in the spreadsheet it refers to