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