Vlookup

[anurag.d]

I use vlookup function on a huge list.
However when a value is not found it returns the #N/A error.
Can anybody tell me a way whereby instead of #N/A error i get a numeri
0.
Means the formula shud first look for the value and return it and i
not found return a zero.
Thanks in advance

 

[englishtwit]

use vlookup function on a huge list.
However when a value is not found it returns the #N/A error.
Can anybody tell me a way whereby instead of #N/A error i get a numeri
0.
Means the formula shud first look for the value and return it and i
not found return a zero.
Thanks in advance.

use an if statement along the lines of
IF(ISNA(A1),"0",B1)
What this statment means is
IF the contents of A1 is #NA then make the contents 0, otherwise pu
the contents of cell B1 in.

Regards
E

 

[PegL]

Or, to do it in one step, make your formula something
like this: =if(isna(vlookup_formula),0,vlookup_formula)

 

[anurag.d]

Right,I want to make it in 1 step.
The formua u suggested is not getting accepted,their seems to be som
erro

 

[anurag.d]

Can anyone solve my problem?

 

[Dave Peterson]

I think PegL did.

If her suggestion didn't work, you may want to post your real formula.