Formula incorrect answer
 

=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

Formula incorrect answer
 

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)



"Wanna Learn" wrote in message
...
=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

Formula incorrect answer
 

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" wrote:

=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

Formula incorrect answer
 

=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" wrote in message
...
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" wrote:

=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