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
|