Need help with finding data from two differing columns

[Paul_Farquhar]

Good Morning,

I have a table with a Shop Order, A date, A name and list of hours.  I am then using this info in different ways.  I am currently trying to track the dates that a person has worked on a shop order.  I had initially though of having a table with names on top and the days of the month on the left and then just have a Yes or a No if each person did work on that day.  However, in reading thru allot of help I could potentially use XLOOKUP or MATCH, but I am having problems 1. getting it to work right and 2. understanding what these do.  I read that I could use an ARRAY, but that is way over my head and I don't know how to format it right.  I would be ok with just a list of names with the associated dates.  What ever would be an easier path.  I just want a quick way to look up if each person has a record for each day.  Hope this is understandable.  Thank you for any help you may be able to provide.  Here is a sample table of the data.

Sales Order	Date	Name	Hours
12345	10/4/2023	Jack	4.5
24680	10/4/2023	Jack	4.5
12345	10/4/2023	Joe	9
10023	10/5/2023	John	9
56412	10/6/2023	Jill	9

[#2]

@Paul_Farquhar 

See the attached demo. It uses just 3 formulas.

[#3 · Accepted solution]

@Paul_Farquhar 

An alternative would be to insert a Pivot Table, as demonstrated in the attached file and change the NumberFormat of one of the Values cells to "Yes";; to achieve the desired output.

[#4]

@Subodh_Tiwari_sktneer thank you all for the suggestions.  I ended up with the pivot table.  While the formulas worked great on my home computer when I tried using them at work, I had issues with it.  I think that is because at work we use Excel 2016.

Thank you again,

Paul

[#5]

You're welcome @Paul_Farquhar! Glad it worked for you.