View Single Post
  #28  
Old July 27th, 2009, 07:36 PM posted to microsoft.public.excel.worksheet.functions
AMLL
external usenet poster
 
Posts: 1
Default How can I lookup when match has more than one value?

I have a flowup question: how can I return all of match up cells in my
spreadsheet?

"bonot1" wrote:

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, or at least a function
that tells me there are duplicate matches?