Thread: How do I change a vlookup reference using the "Text" contents of.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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!


Reply With QuoteReply With Quote