Index and Match

New Contributor

Can anyone help with index and match? I have a report which has columns with Staff Name, Date, AM/PM/ALL DAY, Contract Details. I want to see who is working on what contract AM or PM. The formula works if the third match is just AM or PM but I want to return the value if it is AM or ALL DAY or PM or ALL DAY. See screen shot: 

Shirley1995_0-1649594458434.png

Any help would be much appreciated?

 

 

3 Replies
I think you'll get a quick solution if you're able to upload a sample workbook (w/ any sensitive data removed). Thank you

Thanks for reply. I don't know how to upload a copy of spreadsheet

 

@Shirley1995 

You can upload a sample workbook to a cloud service such as OneDrive, Google Drive or Dropbox, then obtain a link to the uploaded file and post that link in a reply.