View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bonot1 bonot1 is offline
external usenet poster
 
Posts: 4
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, or at least a function
that tells me there are duplicate matches?