Hello,

I am using an IF Vlookup and i am trying to hide the #N/A error and nothing would work. (I want to import the data to a program that cannot read the #N/A)

This is the code

=IF(VLOOKUP(A17,'MT4 Paste'!$A$3:$B$15,2,FALSE)>0,VLOOKUP(A17,'MT4 Paste'!$A$3:$B$15,2,FALSE),0)

or

=IF(D17=0,VLOOKUP(A17,'MT4 Paste'!A3:B30,2,FALSE),0)

(doesnt matter which of the 2 , if i will be able to hide it for 1 i will do it for the rest as well)

I really have to get rid of the #N/A ...

Couldnt make it with conditional formating.
I also tried the ISNA, ISERROR but i cannot combine the 2 IFs, i always get an error.

Any ideas??