I have a formula in O5 ,=CONCATENATE(K4,P10,C19,"#",C20). This formula
returns 0#0. K4 is empty until a macro inputs a number, P10 is empty until
the user inputs data, C19 has the formula
=VLOOKUP(G18,MultiCustomer,3,FALSE), and C20 has the formula
=VLOOKUP(G18,MultiCustomer,4,FALSE). How do I change the formula in O5 to
return nothing if the two lookup formulas (C19 & C20) have not looked up the
data it is designed to. If these to cells are not showing anything they are
not still not empty because they have a formula, thus causing the concatenate
formula to return the zeros. Any ideas???

Mike Rogers