| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to return multiple results in vlookup?
For e.g. in sheet 1,
Column A Column B apple ABC orange DEF apple GHI When I do vlookup in sheet 2, I want to return result in column B if it matches with column A. But say for 'apple', it will only return 'ABC'. Is there any way it can return both results, i.e. ' ABC' and 'GHI' in sheet 2? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to return multiple results in vlookup?
See this:
http://tinyurl.com/mrf8t Biff "Landa" wrote in message ... For e.g. in sheet 1, Column A Column B apple ABC orange DEF apple GHI When I do vlookup in sheet 2, I want to return result in column B if it matches with column A. But say for 'apple', it will only return 'ABC'. Is there any way it can return both results, i.e. ' ABC' and 'GHI' in sheet 2? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to return multiple results in vlookup?
Thanks a lot, Biff!
"Biff" wrote: See this: http://tinyurl.com/mrf8t Biff "Landa" wrote in message ... For e.g. in sheet 1, Column A Column B apple ABC orange DEF apple GHI When I do vlookup in sheet 2, I want to return result in column B if it matches with column A. But say for 'apple', it will only return 'ABC'. Is there any way it can return both results, i.e. ' ABC' and 'GHI' in sheet 2? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to return multiple results in vlookup?
Hello,
Maybe my UDF vlookupall can help you: http://www.sulprobil.com/html/lookup-variants.html HTH, Bernd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MODE() is there a way to return bi-modal or multimodal results? | Excel Worksheet Functions | |||
| return multiple corresponding values using INDEX | Excel Worksheet Functions | |||
| abdualmohsn | Excel Discussion (Misc queries) | |||
| VLOOKUP to return multiple rows | Excel Worksheet Functions | |||
| Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) | |||
Linear Mode
