G
Guest
Guest
I am trying to compare two lists of data, each containing client names.
I want to set a function that tests to see if a name in Col B appears in Col F. So far, I've got this formula:
=IF(MATCH(B8,$F$8:$F$186,0),"Y","N")
It works when the exact match is found, but if no match is found it returns #N/A. Clearly my IF statement isn't working.
Any ideas on where I'm going wrong?
I want to set a function that tests to see if a name in Col B appears in Col F. So far, I've got this formula:
=IF(MATCH(B8,$F$8:$F$186,0),"Y","N")
It works when the exact match is found, but if no match is found it returns #N/A. Clearly my IF statement isn't working.
Any ideas on where I'm going wrong?