Lookup using variable name

R

Rod

Hello,

I have excel range names of:

tblCA10
tblCA15
tblCA20
tblCA25
tblCA30
tblCA35

I would like to do a lookup like this:

=VLOOKUP(C2,tblCAB2,9,FALSE)

where tblCAB2 will be determined by the value entered in B2, i.e. if the
value in B2 is 15 then tblCA15 will be searched.

Thanks
 

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

Variable lookup 6
Variable Cell Reference 2
use cell text in lookup function 3
Using a vlookup to search multiple criteria for one result? 7
Lookup formula problemo 2
Using Lookup 1
LOOKUP or IF-THEN stmt - which one? 8
Lookup less than a number 6

Top