hide #N/A error

[tsioumiou]

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??

[Marcol]

Maybe

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


Hope this helps

[tsioumiou]

Still #N/A unfortunatelly .

It doesn't gives me any errors but the #N/A is still there

[Marcol]

Can't explain that, it works on my test sheet.

Is it possible that the error is in your source sheet and #N/A is a valid result?

[tsioumiou]

It returns #N/A because it cannot find the value that i asked it to find(A17 in this case).

How can the source sheet have an error? There are just data there.

I am trying to make it return 0 or an empty cell if it doesnt find the data.

Thanks for the try anyway

[day92]

tsioumiou please post some sample data with this error so we can better understand your issue.

[CRIMEDOG]

try putting () around the vlookups.

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

[Armando Montes]

Try something like this:
=IF(COUNTIF(B$2:B$7,B23),VLOOKUP(B23,B$2:D$7,2,0),"")