Help with MATCH function

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?

[Aladin Akyurek]

On 2002-02-26 08:39, Anonymous wrote:
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?

Try:

=IF(ISNUMBER(MATCH(B8,$F$8:$F$186,0)),"Y","N")

or simpler:

=IF(COUNTIF($F$8:$F$186,B8),"Y","N")

Thank you - both options worked a treat!

[cool_programmer]

=IF(MATCH(B8,$F$8:$F$186,0),"Y","N") <--------this is wrong
=IF(ISNA(MATCH(B8,$F$8:$F$186,0), "N", "Y") <------try this....

See wat happens is that.......when you use match function........if match doesnt not find the value......it will show #NA error.....so wat i have done is the....i use the ISNA() function that return "True" if the error is #Na else false. I hope u got the idea....go try it......i have not test this in the database.....i hope it works............if not........u can ask me again.....

Programing is my Nick Name