If both rows have X & Y name then cell = Yes or No

[Deleted]

I'm having a problem where it spills over.

If there is a name in the first and second cell, that is acceptable, then it will say YES

If its blank, or if its a different persons name, it will say NO

Please help! thank you

[#2 · Accepted solution]

@Deleted 

Try this:

=IF(AND(ISNUMBER(MATCH(A2,G:G,0)),ISNUMBER(MATCH(B2,G:G,0))),"YES","NO")

Not sure if this is in your sheet on Sharepoint now. Managed to over-write what I found earlier. Perhaps someone else goes in after me an does the same. Not used to working in Sharepoint.

[#3]

@Riny_van_Eekelen 

I saw you in there doing your work. thank you very much.thank you

[#4]

@Deleted Glad I could help!