Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup returning a value in more than one cell
I am using the VLOOKUP formula to return a value in a cell based on a
validation list. I want to know if I pick something in the list can I have it fill in one cell with a value from one column and another cell with a value from another column. For example: A B C Program Description Products Banking At Work description 1 online, mail, etc Internet Banking description 2 bill pay etc I want to pick something from the program column and have the description fill in the next column and the products fill in the one after that. I have Column A named Program as a range a2:a3, I have description 1 named BankingAtWork and this works with the VLOOKUP However, I don't know how to get column C to work with VLOOKUP based on the Programs. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup is returning a value one cell above the correct cell. | Excel Worksheet Functions | |||
Leave cell data (IF(ISNA(VLOOKUP) is TRUE instead of returning blank (" ") or #NA | Excel Worksheet Functions | |||
vlookup returning #NA | Excel Discussion (Misc queries) | |||
Vlookup returning #N/A | Excel Worksheet Functions | |||
Vlookup and returning #n/a | Excel Worksheet Functions |