View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kpotg24 kpotg24 is offline
external usenet poster
 
Posts: 1
Default Offset/Match when there is more than 1 result

I am working on a spreadsheet where I have a list of names and I need to
return the corresponding dates to the names. There are instances where I
will have the same name multiple times with different dates. I have no
problem getting the information when the name is only shown once, is there an
easy way to retrieve this information when there are multiple results?
Example below:

A B C D
Susan Miller NO YES 11/01/09
Susan Miller NO YES 04/09/05
Todd Smith NO YES 10/01/09

I only need the name and the dates. Thanks!