Vlookup formula
in [Functions]
|
Prev: how do i set up a user prompt at the start of an excel workbook ?
Next: can I autopopulate from a long drop down list in Excel?
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 > |