IF and VLOOKUP statemanet...need to get rid of #N/A and get 0 instead

[ajajmannen]

Hi!!

I have Excel 2002 and have a problem. I have a formula that compare the Data between to sheets. I want to when there is no match for the formula to return the value 0 but instead it keeps returning #N/A and I can't find a way to change it.
I have tried with another If statement in the middle but without luck.

Please help me?

Formula:
=IF(VLOOKUP(A3;Månad_innan!$A$2:$M$4000;13;FALSE)<>"";VLOOKUP(A3;Månad_innan!$A$2:$M$4000;13;FALSE);"")

[daddylonglegs]

Try

=IF(ISNA(VLOOKUP(A3;Månad_innan!$A$2:$M$4000;13;FALSE));0;VLOOKUP(A3;Månad_innan!$A$2:$M$4000;13;FALSE))

[ajajmannen]

Hi!

Thanks for the tip it really helped me.
I added some stuff for it to be complete

This is the result and it worked like a charm
=IF(ISNA(VLOOKUP(A2;Månad_innan!$A$2:$M$4000;13;FALSE));"0";VLOOKUP(A2;Månad_innan!$A$2:$M$4000;13;FALSE)-(M2*2)+(-1)-(O2+P2+Q2+R2+S2+T2+U2+V2))

[NKRA]

How about it is just Vlookup simple no If or nested formula

I dont think Isnot numeric will work


Any other suggesstions


NK