View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Heine Heine is offline
external usenet poster
 
Posts: 49
Default 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