How do I change a vlookup reference using the "Text" contents of.

[Guest]

I want to use the contents of a cell within a vlookup formula.
For example:
$A$1 = ABCD.
$A$2 = $A$1&"_Info_Table" or ABCD_Info_Table
$B$1 = EFGH
$C$1 = vlookup($a$2,ABCD_Info_Table,3)

In other words, I want to substitue the results of $A$2 for typing in
ABCD_Info_Table.

Any help is appreciated!

 

[Tom Ogilvy]

$C$1 = vlookup($a$2,Indirect($A$1&"_Info_Table"),3)

 

[Guest]

Tom,

Thank you so much fo responding. This was a great help!

Blanton