Thread: How do I change a vlookup reference using the "Text" contents of.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BCW BCW is offline
external usenet poster
  
Posts: 5
Default 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!
Reply With QuoteReply With Quote