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