Blank cell instead of zero

C

CBrausa

I want to pull info from my master over to other sheets, if nothing is
in the cell I want it to return a blank cell instead of zero so this is
the formula I am using. The only problem is my formulas start row 12,
rows 15-28 either won't pull info over or if blank it puts in a zero.
29-560 works fine then in row 561-596 nothing, zeros, or #NA.

=IF(LEN(VLOOKUP($A12,'FD RUN LIST -
MASTER'!$A$12:$N$596,$B$17))=0,"",(VLOOKUP($A12,'FD RUN LIST -
MASTER'!$A$12:$N$596,$B$17,FALSE)))

Is there another formula I should use so I get a blank instead of zero?
 
D

Dave Peterson

I think your formula is as good as any, but I use this variation:

=if(vlookup(...)="","",vlookup(...))

or
=if(iserror(vlookup(...)),"missing",if(vlookup(...)="","",vlookup(...))))
 
C

CBrausa

I used the same formula and added,FALSE in the first part of the formul
and now it works.:rolleyes:
Thanks for your hel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Want a blank not zero 1
Excel - in a row of numbers, put last entered number Cell B2 7
reading a blank cell as zero 5
#N/A 5
cells with zero value are shown as blank, not zero 2
I need a blank value or zero instead of a #VALUE! error. 3
Return a 0 when vlookup returns #n/a 2
Return Blank instead of Zero 9

Top