From: Vijay on 11 Feb 2010 07:35 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 From: Max on 11 Feb 2010 07:40 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 > From: Mike H on 11 Feb 2010 07:43 Hi, Test the range for your lookup value =IF(COUNTIF(A1:A20,C1)=0,0,VLOOKUP(C1,A1:B20,2,FALSE)) -- 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 > From: Gary''s Student on 11 Feb 2010 07:46 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 >