C
CBrausa
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.
=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)))
cell.
This is the formula I entered. I did one before and I got a blank so I
must be doing something wrong.
=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)))