Apr 10 2022 05:43 AM - edited Apr 10 2022 12:37 PM
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:
Any help would be much appreciated?
Apr 10 2022 11:24 AM
Apr 10 2022 12:32 PM - edited Apr 10 2022 12:40 PM
Thanks for reply. I don't know how to upload a copy of spreadsheet :(
Apr 10 2022 12:57 PM
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.