Formula incorrect answer

[Guest]

=IF(ISERROR(VLOOKUP(D2,'[Reorder point report
21907.xls]Sheet1'!$A$4:$K$4861,3,FALSE))," ",VLOOKUP(D2,'[Reorder point
report 21907.xls]Sheet1'!$A$4:$K$4861,3,FALSE))
Hello above is my formula ... formula works ok except when the entry is
blank my answer is 0 I want the answer to be blank thanks

 

[Bob Phillips]

I can't see how that gives 0, it looks like spaces to me. I would change it
to this though

=IF(ISERROR(VLOOKUP(D2,'[Reorder point report >
21907.xls]Sheet1'!$A$4:$K$4861,3,FALSE)),
"",VLOOKUP(D2,'[Reorder point report
21907.xls]Sheet1'!$A$4:$K$4861,3,FALSE))


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Hello want to clarify this request ... my answer should be
if NA, it should say NA , if product is found but there is no answer, it
should be blank not 0, and if the product is found ...whatever the product
is . I think I 'm missing a statement? thanks again

 

[Bob Phillips]

=IF(ISNA(VLOOKUP(D2,'[Reorder point report
21907.xls]Sheet1'!$A$4:$K$4861,3,FALSE)),NA(),
IF(VLOOKUP(D2,'[Reorder point report
21907.xls]Sheet1'!$A$4:$K$4861,3,FALSE)=0,"",
VLOOKUP(D2,'[Reorder point report 21907.xls]Sheet1'!$A$4:$K$4861,3,FALSE)))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

Hello want to clarify this request ... my answer should be
if NA, it should say NA , if product is found but there is no answer, it
should be blank not 0, and if the product is found ...whatever the
product
is . I think I 'm missing a statement? thanks again

=IF(ISERROR(VLOOKUP(D2,'[Reorder point report
21907.xls]Sheet1'!$A$4:$K$4861,3,FALSE))," ",VLOOKUP(D2,'[Reorder
point
report 21907.xls]Sheet1'!$A$4:$K$4861,3,FALSE))
Hello above is my formula ... formula works ok except when the entry is
blank my answer is 0 I want the answer to be blank thanks