Formula incorrect answer

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)
 
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(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)



Wanna Learn said:
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

Wanna Learn said:
=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
Click to expand...
Click to expand...
 
Back
Top