| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| correct syntax for nesting "if", "and", and "vlookup"....if possib | Excel Worksheet Functions | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| can i change "A" to "Name" in reference to columns | Excel Discussion (Misc queries) | |||
| How do I reference a cell as PART of a vlookup "Table_Array" locat | Excel Worksheet Functions | |||
| get the VLOOKUP function to return the "contents" of a cell? | Excel Worksheet Functions | |||
Linear Mode
