Variable lookup

[Rod]

Hello,

Im not sure if this double posted because me browser froze...

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

 

[Max]

=VLOOKUP(C2,tblCAB2,9,FALSE)

where tblCAB2 will be determined by the value entered in B2,

Try INDIRECT, ie: =VLOOKUP(C2,INDIRECT(B2),9,FALSE)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---

 

[Rod]

#REF! error

Try INDIRECT, ie: =VLOOKUP(C2,INDIRECT(B2),9,FALSE)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik

 

[Max]

Sorry, missed your last line earlier:

if the value in B2 is 15 then tblCA15 will be searched.

Try: =VLOOKUP(C2,INDIRECT("tblCA"&B2),9,FALSE)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---

 

[Max]

#REF! error

Sorry, missed your last line earlier:

if the value in B2 is 15 then tblCA15 will be searched.

Try: =VLOOKUP(C2,INDIRECT("tblCA"&B2),9,FALSE)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---

 

[Rod]

Perfect!

Sorry, missed your last line earlier:

Try: =VLOOKUP(C2,INDIRECT("tblCA"&B2),9,FALSE)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik

 

[Max]

Welcome
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik