| 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. |
| 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) | |||
Threaded Mode
