ExcelBanter - VLOOKUP using cell reference

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - VLOOKUP using cell reference (https://www.excelbanter.com/excel-worksheet-functions/105861-vlookup-using-cell-reference.html)

Lee Harris

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

Niek Otten

VLOOKUP using cell reference

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

All times are GMT +1. The time now is 12:47 PM.