Variable lookup
 

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

Variable lookup
 

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

Variable lookup
 

#REF! error

"Max" wrote:

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

Variable lookup
 

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

Variable lookup
 

"Rod" wrote:
#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
---

Variable lookup
 

Perfect!

"Max" wrote:

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

Variable lookup
 

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