if,match fonction

Hi

I tried with:

" =IF(MATCH(C5,'Q7'!A3:A302,0)," ","Code not found") "

but when it does not match instead of "Code not fond" i get #N/A what can i do?

Thanx

s_zabihi,

Use IsNumber() to verify that Match() doesn't result in an error:
=IF(ISNUMBER(MATCH(C5,'Q7'!A3:A302,0))," ","Code not found")