Handling #N/A error with VLOOKUP( ) inside of an IF( )

[DashboardNovice]

=IF(VLOOKUP(C5,$K:$K,1,0)="#N/A","Error","OK")

With this formula, the VLOOKUP returns an #N/A error which equals "#N/A" therefore the condition should evaluate as TRUE and return the word "Error," but instead it returns #N/A.

What is wrong here?

 

[pecoflyer]

Perhaps
=IF(ISNA(VLOOKUP(C5,$K:$K,1,0)),"Error","OK")
In this case however
=IF(MATCH(C5,$K:$K,0),"OK","Error")
does the same as you are searching a one-column range
(IMO using entire columns is bad practice)

 

[bosco_yip]

Perhaps
=IF(ISNA(VLOOKUP(C5,$K:$K,1,0)),"Error","OK")
In this case however
=IF(MATCH(C5,$K:$K,0),"OK","Error")
does the same as you are searching a one-column range
(IMO using entire columns is bad practice)

This formula:=IF(MATCH(C5,$K:$K,0),"OK","Error")

It will return #N/A, if the formula does not found the Lookup value

so

It should be:

=IF(ISNA(MATCH(C5,$K:$K,0)),"OK","Error")

Regards

 

[pecoflyer]

This formula:=IF(MATCH(C5,$K:$K,0),"OK","Error")

It will return #N/A, if the formula does not found the Lookup value

Thanks for the heads-up