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

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!

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

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

--
Regards,
Tom Ogilvy

"BCW" wrote in message
...
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!

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

Tom,

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

Blanton

"BCW" wrote:

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!