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
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
Last edited by s_zabihi; 12-01-2011 at 06:27 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks