Vlookup Formula that references a Table

[maclachlan19]

I'm trying to use a vlookup formula that references a cell to obtain the table name

Example
=vlookup(B3,C2,2,FALSE)

I have mutliple tables in another sheet, all tables are uniquely named.
I want the user to be able to change the value of C2 which will essentially change the table that the formula references.

Thanks

 

[Aladin Akyurek]

Looks like you mean...

=VLOOKUP(B3,INDIRECT(C2),2,0)

 

[maclachlan19]

Thank you Aladin, that works great!!

 

[Aladin Akyurek]

Thank you Aladin, that works great!!

You are welcome.