Look in HELP for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Lee Harris" wrote in message ...
| 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
|
|