Cross reference person, date from database

[noahwass]

In the attached spreadsheet, I am trying to figure out the best way to place a 'y' or 'n' in the Supervisor Report sheet, columns C through E. A 'y' for the employee being listed in the Data sheet on the date that matches column B and an 'n' if not.

[Pete_UK]

You can use this formula in cell C4 of the Supervisor Report sheet:

=IF(COUNTIFS(Data!$E:$E,C$3,Data!$B:$B,$B4),"y","n")

then copy across and down as required.

Hope this helps.

Pete

[noahwass]

Pete, that worked great. Thanks for the support and quick response.

[Pete_UK]

Glad to help, and thanks for the rep.

If that concludes your query, please use the Thread Tools menu option above your first post in this thread and mark the thread as Solved.

Pete