V Vijay Feb 11, 2010 #1 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
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
M Max Feb 11, 2010 #2 One way, just do a front-check on that lookup cell, indicatively: =IF(A2="",0,VLOOKUP(A2,....)) voila? hit the YES below
One way, just do a front-check on that lookup cell, indicatively: =IF(A2="",0,VLOOKUP(A2,....)) voila? hit the YES below
M Mike H Feb 11, 2010 #3 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.
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.
G Gary''s Student Feb 11, 2010 #4 Test for N/A: =IF(ISNA(VLOOKUP(5,G$1:H$44,2,FALSE)),0,VLOOKUP(5,G$1:H$44,2,FALSE))
