Lookup 2 criteria and return yes or no

[Claire Jackson]

Hi,

I have a spreadsheet where I am looking in a list for a name and also a date and return yes if there is a match for both but the following formula isn't working. Please help.

=IF(XLOOKUP($C6,Sheet1!$E$2:$E$300,E$2,Sheet1!$F$2:$F$300),"Yes","No")

C6 has the employee name and F2 has the date I need to match, Sheet 1 has the data it's searching in (column E the name and column F lookup the date.

 

[RoryA]

You could use:

=IF(COUNTIFS(Sheet1!$E$2:$E$300,$C6,Sheet1!$F$2:$F$300,E$2),"Yes","No")

 

[Claire Jackson]

LIFESAVER!!. Thank you so much x

 

[RoryA]

Glad we could help.