vlookup - more than one result



Hello everybody,

Does anybody know if it is possible to create a lookup formula, which
returns all values if more than one?

For instance:

1 Tom
1 Dick
1 Harry

Then I want it to return all three names when looking up 1.



Best regards
Heine

.



Relevant Pages

  • Re: vlookup - more than one result
    ... Tom ... Dick ... Harry ... Best regards ...
    (microsoft.public.excel.worksheet.functions)
  • Re: goodbye Dick G....good riddence
    ... First David and now Dick G telling him to go ... Tom in Ct ... This the same John that thinks dickhead is a nice guy? ...
    (rec.travel.cruises)
  • goodbye Dick G...good riddence
    ... First David and now Dick G telling him to go ... Tom in Ct ... Of course, without exeception, should you encounter someone on a cruise, ...
    (alt.vacation.las-vegas)
  • goodbye Dick G....good riddence
    ... First David and now Dick G telling him to go ... Tom in Ct ... Of course, without exeception, should you encounter someone on a cruise, ...
    (rec.travel.cruises)
  • Re: 7 card stud question
    ... Tom: X X Qs Qc ... Dick: X X 5h 7c ... You almost have to raise. ... you brick, you'd be right to fold to a bet and a raise). ...
    (rec.gambling.poker)