vlookup

E

Ed Davis

Is there a way to use vlookup depending on what is in a cell.
example I have several ranges on separate tabs each tab is numbered lets say
they are 324, 345, 567,321
Each range is the same a1..j50
In the input sheet if I put in cell c4 the number 324 I want it to lookup in
the range that is in tab 324
The lookup starts in cell f 10 of the input sheet

Thanks in advance
Ed Davis
 
D

Domenic

Ed Davis said:
Is there a way to use vlookup depending on what is in a cell.
example I have several ranges on separate tabs each tab is numbered lets say
they are 324, 345, 567,321
Each range is the same a1..j50
In the input sheet if I put in cell c4 the number 324 I want it to lookup in
the range that is in tab 324
The lookup starts in cell f 10 of the input sheet

Thanks in advance
Ed Davis
Click to expand...


Have a look at the INDIRECT function...

=VLOOKUP(F10,INDIRECT("'"&$C$4&"'!A1:J50"),2,0)
 
Top