View Single Post
  #10  
Old June 15th, 2008, 01:18 PM posted to microsoft.public.excel.worksheet.functions
farhad
external usenet poster
 
Posts: 3
Default How can I lookup when match has more than one value?

I am using LOOKUP functions to retrieve info from a list. Some of the lookup
values have more than one match in the list. Is there a function that allows
me to retrieve multiple elements for one lookup value? Offcourse the data is
in random order, and the data to be returned is text. I need to have all the
records that lookup retrieve it on the same rows.