Hi Guys
Looking to use a formula - probably VLOOKUP - My sheat is a much larger version of the below table that lists employee's first name, surname and then all the dates for a year. I then enter if someone is "A" for "Available", AM for "Available AM only" or PM for "Available PM only".
What I want to do is have a formula where I can just enter a date such as 04-07 below and it will display the 2 employee's who have listed any of A, AM or PM. Would be great if it can be done with both first name and surname (they are on 2 different columns)
<tbody>
</tbody>
Looking to use a formula - probably VLOOKUP - My sheat is a much larger version of the below table that lists employee's first name, surname and then all the dates for a year. I then enter if someone is "A" for "Available", AM for "Available AM only" or PM for "Available PM only".
What I want to do is have a formula where I can just enter a date such as 04-07 below and it will display the 2 employee's who have listed any of A, AM or PM. Would be great if it can be done with both first name and surname (they are on 2 different columns)
First Name | Surname | 01-07 | 02-07 | 03-07 | 04-07 | 05-07 | 06-07 | 07-07 | |
John | Smith | A | AM | PM | A | ||||
Sam | Black | PM | |||||||
Bill | White | A | A | PM | |||||
James | Blue | AM | |||||||
<tbody>
</tbody>