Thread: Match Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Melanie Melanie is offline
external usenet poster
 
Posts: 78
Default Match Function

Hi,
I have put together a spreadsheet to find codes, states, descriptions. It
finds the data by dates.
Columns a Dates, Codes, States, Descriptions
If I put in a date it matches the code, state and description.

My problem is that if I have 2 dates that are the same it will only match
the first date it can find. What kind of formula do I need so that it will
output the second or third date data.

Thanks for your help.
If you need a copy of the spreadsheet please let me know.