It depends exactly on how your formula works. The normal approach would
be:

=IF(ISNA(your_formula),"",your_formula)

But if the error is caused solely because of the reference cell being
empty (assume this is A1), then you could also try:

=IF(A1="","",your_formula)

Hope this helps.

Pete

Colin wrote:
How can I keep cells blank (that have vlookup function in) until there is
data in the cell being referenced