Iam using vlookup formula and the ce;ll which has no value gives me #N/A. I
want 0 there.How can I do that.
Thanks
Vijay

One way, just do a front-check on that lookup cell, indicatively:
=IF(A2="",0,VLOOKUP(A2,....))
voila? hit the YES below
--
Max
Singapore
---
"Vijay" wrote:
I am using vlookup formula and the cell which has no value gives me #N/A. I
want 0 there.How can I do that.
Thanks
Vijay

Hi,

Test the range for your lookup value

=IF(COUNTIF(A1:A20,C1)=0,0,VLOOKUP(C1,A1:B20,2,FAL SE))


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Vijay" wrote:

Iam using vlookup formula and the ce;ll which has no value gives me #N/A. I
want 0 there.How can I do that.
Thanks
Vijay

Test for N/A:

=IF(ISNA(VLOOKUP(5,G$1:H$44,2,FALSE)),0,VLOOKUP(5, G$1:H$44,2,FALSE))

--
Gary''s Student - gsnu201001


"Vijay" wrote:

Iam using vlookup formula and the ce;ll which has no value gives me #N/A. I
want 0 there.How can I do that.
Thanks
Vijay