software

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,quot;quot;,(VLOOKUP($A12,'F D 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?--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile: www.excelforum.com/member.php...oamp;userid=24677
View this thread: www.excelforum.com/showthread...hreadid=513197I think your formula is as good as any, but I use this variation:

=if(vlookup(...)=quot;quot;,quot;quot;,vlookup(...))

or
=if(iserror(vlookup(...)),quot;missingquot;,if(vlookup(... )=quot;quot;,quot;quot;,vlookup(...))))

CBrausa wrote:
gt;
gt; I want to pull info from my master over to other sheets, if nothing is
gt; in the cell I want it to return a blank cell instead of zero so this is
gt; the formula I am using. The only problem is my formulas start row 12,
gt; rows 15-28 either won't pull info over or if blank it puts in a zero.
gt; 29-560 works fine then in row 561-596 nothing, zeros, or #NA.
gt;
gt; =IF(LEN(VLOOKUP($A12,'FD RUN LIST -
gt; MASTER'!$A$12:$N$596,$B$17))=0,quot;quot;,(VLOOKUP($A12,'F D RUN LIST -
gt; MASTER'!$A$12:$N$596,$B$17,FALSE)))
gt;
gt; Is there another formula I should use so I get a blank instead of zero?
gt;
gt; --
gt; CBrausa
gt; ------------------------------------------------------------------------
gt; CBrausa's Profile: www.excelforum.com/member.php...oamp;userid=24677
gt; View this thread: www.excelforum.com/showthread...hreadid=513197

--

Dave Peterson


But why is it not reading some cells?--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile: www.excelforum.com/member.php...oamp;userid=24677
View this thread: www.excelforum.com/showthread...hreadid=513197
I have tried the suggestions and in some cells I am still getting
zeros.
Why?--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile: www.excelforum.com/member.php...oamp;userid=24677
View this thread: www.excelforum.com/showthread...hreadid=513197Maybe the matched cell really contains a 0?

What formula did you use?

CBrausa wrote:
gt;
gt; I have tried the suggestions and in some cells I am still getting
gt; zeros.
gt; Why?
gt;
gt; --
gt; CBrausa
gt; ------------------------------------------------------------------------
gt; CBrausa's Profile: www.excelforum.com/member.php...oamp;userid=24677
gt; View this thread: www.excelforum.com/showthread...hreadid=513197

--

Dave Peterson


I used the same formula and added,FALSE in the first part of the formula
and now it works.
Thanks for your help--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile: www.excelforum.com/member.php...oamp;userid=24677
View this thread: www.excelforum.com/showthread...hreadid=513197