ExcelBanter - Lookup using variable name

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Lookup using variable name (https://www.excelbanter.com/excel-worksheet-functions/206710-lookup-using-variable-name.html)

Rod

Lookup using variable name

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

Max

Lookup using variable name

See response to your later posting
(use INDIRECT)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---

All times are GMT +1. The time now is 01:44 AM.