Multuiple Lookup Tables

[Dingerz]

Hi Guys, I want to use lookup tables on multiple tables. I was hoping to
somewhow have the user select the table from a drop down menu (eg Table 1)
then have the lookup function change to search through the selected table.
Any suggestions?

 

[Liliana]

=VLOOKUP(A17,INDIRECT(B17),2)


Where B17 contains selected table name.

 

[Dingerz]

Thanks for that however I want it to refer to another worksheet. So for
example i have at the moment:
=OFFSET('SAFT LE Range'!A1,MATCH(Calculator!F41,'SAFT LE Range'!B8:B41,1),0)

i want something like this

=OFFSET(INDIRECT(D42,A1),MATCH(Calculator!F41,INDIRECT(D42)!B8:B41,1),0)

I know its incorrect but you get the idea.

 

[Max]

If D42 contains the sheetname: SAFT LE Range
Then this should be what you seek to do
=OFFSET(INDIRECT("'"&D42&"'!A1"),MATCH(Calculator!F41,INDIRECT("'"&D42&"'!B8:B41"),1),0)

Success? Punch it here, click the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik