how to return multiple results in vlookup?

[Guest]

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?

 

[Biff]

See this:

http://tinyurl.com/mrf8t

Biff

 

[Guest]

Thanks a lot, Biff!

See this:

http://tinyurl.com/mrf8t

Biff

 

[bplumhoff]

Hello,

Maybe my UDF vlookupall can help you:
http://www.sulprobil.com/html/lookup-variants.html

HTH,
Bernd