Stop #N/A until data in the reference cell
 

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

Stop #N/A until data in the reference cell
 

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

Stop #N/A until data in the reference cell
 

check the match function

=IF(ISNA(MATCH(arg1, arg2, arg3)), "", VLOOKUP(arg1, arg2, arg3, arg4))


"Colin" wrote:

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

Stop #N/A until data in the reference cell
 

Sorry, must be being a bit thick here. Tried that and cell stays blank all
the time.
My formula is =vlookup(A1,Items,2) Items being the referecne chart on
sheet 2,
Any more on this thanks.

"Pete_UK" wrote:

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