Vlookup

A

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
 
E

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
 
P

PegL

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

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
 
D

Dave Peterson

I think PegL did.

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