IfNa

[KIM Chanthan]

Anyone can help me on such easy fomular?
I dont know why I couldn't do it.

Thank,

 

[trprasad78]

Use iferror() in column K
=IFERROR(VLOOKUP(A3,$F$3:$I$3095,4,0),"")

Refer attached file.

 

[Khalid NGO]

Hi Kim Chanthan,

Always set a meaningful title, just 4 alphabets makes no sense.

Try the solution provided above, or use IFERROR for column L.


Quoting your text in the attachment:

*** Do you know what wrong with colum L? I mean in cell L4 and L6 should be appear with blank as per my fomular, but why it still appear #N/A?

See how your OR formula in L4 produce error:

=IF(OR(K4=D4,ISNA(K4)),"","Error")
Evaluate the first OR condition, you will see #N/A, and TRUE for 2nd:

=IF(OR(#N/A,TRUE),"","Error")

=IF(#N/A,"","Error")

#N/A
Regards,

 

[ANKUSHRS1]

something went wrong...still u can use below formula

=IF(ISERROR(IF(OR(K3=D3,ISNA(K3)),"","Error"))=TRUE,"",IF(OR(K3=D3,ISNA(K3)),"","Error"))