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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding value using greater than, Vlookup, and nested If 2
Link data from particular sheet based on cell reference 1
VLOOKUP returns #N/A 9
Vary the Range in a Function 3
Vlookup and Indirect help!! 2
VLOOKUP 14
Vlookup, Index or Match - Problem 2
VLOOKUP forumla for Excel HELP! 1

Top