Convert Cell Content To Table Name

[davidylam]

On cell I35, it contains an IF Statement, the result is "Table1" o
"Table2".

I wants to use I35 as a table name in the VLOOKUP Function, is tha
possible?

=VLOOKUP(C12,I35,I36,FALSE)

C12 is the lookup value
I35 represents the table name
I36 contains the column to look up
False exact match

I can't figure out how to let Excel know that I35 is a table name.

Thanks in advance.

(e-mail address removed)

 

[Frank Kabel]

Hi
try
=VLOOKUP(C12,INDIRECT(I35),I36,FALSE)

I36 should be a number in this case