Want a blank not zero
 

I would like the cell to be blank, instead of zero, if nothing is in the
cell.
This is the formula I entered. I did one before and I got a blank so I
must be doing something wrong.:confused:

=IF(LEN(VLOOKUP(A2,'FD RUN LIST MASTER2'!$A$12:$AM$606,'FD RUN LIST
MASTER2'!$C$12))=0," ",(VLOOKUP(A2,'FD RUN LIST
MASTER2'!$A$12:$AM$606,'FD RUN LIST MASTER2'!$C$12,FALSE)))


--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677
View this thread: http://www.excelforum.com/showthread...hreadid=519930

Want a blank not zero
 

TRy

=IF(ISNA(VLOOKUP(A2,'FD RUN LIST MASTER2'!$A$12:$AM$606,'FD RUN LIST
MASTER2'!$C$12))," ",
(VLOOKUP(A2,'FD RUN LIST MASTER2'!$A$12:$AM$606,'FD RUN LIST
MASTER2'!$C$12,FALSE)))


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"CBrausa" wrote in
message ...

I would like the cell to be blank, instead of zero, if nothing is in the
cell.
This is the formula I entered. I did one before and I got a blank so I
must be doing something wrong.:confused:

=IF(LEN(VLOOKUP(A2,'FD RUN LIST MASTER2'!$A$12:$AM$606,'FD RUN LIST
MASTER2'!$C$12))=0," ",(VLOOKUP(A2,'FD RUN LIST
MASTER2'!$A$12:$AM$606,'FD RUN LIST MASTER2'!$C$12,FALSE)))


--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile:
http://www.excelforum.com/member.php...o&userid=24677
View this thread: http://www.excelforum.com/showthread...hreadid=519930