Change #N/A to another text automaticly

**Crispy85** · 07-10-2013, 03:23 AM

Hi guys!

I'm building a template and i don't like #N/A notifications lol.

What i'm doing is a vlookup and the result should be #N/A, but instead of the error message i would like to see "Ok!" for example. And when the result isn't #N/A i'd like to see "Not ok!" for example.

Is there an easy way to fix this?

Thanks and regards!

**benishiryo** · 07-10-2013, 03:27 AM

hi there. so you don't want the VLOOKUP results, but just "ok" or "not ok"? seems like you can make do with COUNTIF. but anyway, try:
=IF(ISNA(Vlookup formula),"Not ok!","Ok!")

COUNTIF would be:
=IF(COUNTIF(A1:A10,B1),"Ok!","Not ok!")

**Crispy85** · 07-10-2013, 03:31 AM

Thank you very much sir!

But i just found the answer for the isna a couple of posts below mine lol!

I still give you a *.

Have a nice day.

**Crispy85** · 07-10-2013, 03:38 AM

Originally Posted by benishiryo

hi there. so you don't want the VLOOKUP results, but just "ok" or "not ok"? seems like you can make do with COUNTIF. but anyway, try:
=IF(ISNA(Vlookup formula),"Not ok!","Ok!")

COUNTIF would be:
=IF(COUNTIF(A1:A10,B1),"Ok!","Not ok!")

benishiryo,

Since you are a guru

, i like to ask you if you would take a look at another topic i created but have no solution still, after many hours of experimenting...

This is the link to the topic..

http://www.excelforum.com/excel-prog...eccessary.html