Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP and return formula
Is it possible to use VLOOKUP and return a formula? Here is my situation:
Spreadsheet 1 Column A Column B Column C Equity C ABC123 Muni 912822xd Moneymkt 8145332x Option Spreadsheet 2 Column A Column B Column C Column D Equity concatenate(B2," ","EQUITY") Muni concatenate(C2," ","GOVT") Moneymkt concatenate(C2," ","GOVT") Option concatenate(B2," ","OPT") My goal is to vlookup spreadsheet 1 on Column a to spreadsheet 2 (matching on column a) and return the formula in column d. Many thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP and return formula
Please do not double-post - see your other thread for one approach.
Pete On Feb 8, 8:54*pm, JE wrote: Is it possible to use VLOOKUP and return a formula? *Here is my situation: Spreadsheet 1 Column A * * * Column B * * *Column C * * * Equity * * * * * * * *C * * * * * * ABC123 * * * * * Muni * * * * * * * * * * * * * * * * 912822xd * * * Moneymkt * * * * * * * * * * * * 8145332x * * * Option * * * * * * * * * * * * * * * * * * * * * * * * * Spreadsheet 2 Column A * * * Column B * * *Column C * * *Column D Equity * * * * * * * * * * * * * * * * * * * * * * * * * *concatenate(B2," ","EQUITY") Muni * * * * * * * * * * * * * * * * * * * * * * * * * * *concatenate(C2," ","GOVT") Moneymkt * * * * * * * * * * * * * * * * * * * * * * *concatenate(C2," ","GOVT") Option * * * * * * * * * * * * * * * * * * * * * * * * * concatenate(B2," ","OPT") My goal is to vlookup spreadsheet 1 on Column a to spreadsheet 2 (matching on column a) and return the formula in column d. Many thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP and return formula
Thanks Pete - I received an error message that my post was not succssful
which prompted the second. Appreciate the "gentle reminder" "Pete_UK" wrote: Please do not double-post - see your other thread for one approach. Pete On Feb 8, 8:54 pm, JE wrote: Is it possible to use VLOOKUP and return a formula? Here is my situation: Spreadsheet 1 Column A Column B Column C Equity C ABC123 Muni 912822xd Moneymkt 8145332x Option Spreadsheet 2 Column A Column B Column C Column D Equity concatenate(B2," ","EQUITY") Muni concatenate(C2," ","GOVT") Moneymkt concatenate(C2," ","GOVT") Option concatenate(B2," ","OPT") My goal is to vlookup spreadsheet 1 on Column a to spreadsheet 2 (matching on column a) and return the formula in column d. Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Formula to return the row count of a value in Vlookup | Excel Discussion (Misc queries) | |||
vlookup formula fails to return data search item is text | Excel Worksheet Functions | |||
Return a text string when the result of VLOOKUP formula is #N/A | Excel Worksheet Functions | |||
Vlookup - return row no. instead of value | Excel Discussion (Misc queries) |