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,'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: http://www.excelforum.com/member.php...o&userid=24677
View this thread: http://www.excelforum.com/showthread...hreadid=513197

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

CBrausa wrote:

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,'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: http://www.excelforum.com/member.php...o&userid=24677
View this thread: http://www.excelforum.com/showthread...hreadid=513197

--

Dave Peterson

But why is it not reading some cells?


--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677
View this thread: http://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: http://www.excelforum.com/member.php...o&userid=24677
View this thread: http://www.excelforum.com/showthread...hreadid=513197

Maybe the matched cell really contains a 0?

What formula did you use?

CBrausa wrote:

I have tried the suggestions and in some cells I am still getting
zeros.
Why?

--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677
View this thread: http://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: http://www.excelforum.com/member.php...o&userid=24677
View this thread: http://www.excelforum.com/showthread...hreadid=513197