Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup to return 2 columns
hi
can use vlookup function to return with 2 columns value ? example: A B C 1 H Home $200 2 C Car $100 3 B Boat $250 by using the above range, i know how to use the vlookup to return, say, A1, it return for me "Home"...(i.e: =vlookup(lookupValue,A1:C3,2) how can i use the lookup to return more than 1 data, example, base on the above, I want it to display for me "Home" and "$200", and have them place in separated cell? any help community ? thanks community :) -- oldLearner57 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup 3 columns all return same | Excel Discussion (Misc queries) | |||
Can I return multiple columns from a vlookup? | Excel Worksheet Functions | |||
How do I return the row for a value I VLOOKUP? | Excel Worksheet Functions | |||
Vlookup return multiple columns | Excel Worksheet Functions | |||
Want VLookup to Return the row above | Excel Worksheet Functions |