VLOOKUP using cell reference

L

Lee Harris

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
 
N

Niek Otten

Look in HELP for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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
|
|
 
Top