Feb 06 2020 10:48 AM - edited Feb 06 2020 12:27 PM
Feb 06 2020 10:48 AM - edited Feb 06 2020 12:27 PM
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
Feb 06 2020 12:14 PM
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.
Feb 06 2020 12:15 PM
Feb 06 2020 12:18 PM
@Deleted Glad I could help!
Feb 06 2020 12:14 PM
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.