View Single Post
  #29   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AMLL AMLL is offline
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?