question regarding IF worksheet function

I have a formulae MATCH(AA393,$B$393:$G$393,0) that gives #N/A sometimes when the value could not be matched.

I would like to convert #N/A into a number "0" so i could make use of other formulae functions.

I tried:
=IF(MATCH(AA393,$B$393:$G$393,0)="#N/A","0","1")

but it didnt work..

May I know the correct forumlae that is needed to help solve this problem?

thanks admin.

Hi,

Try:
=IF(ISERROR(MATCH(AA393,$B$393:$G$393,0)),0,MATCH(AA393,$B$393:$G$393,0))

HTH,

SamuelT

ty for helping. it worked. =D