Stop #N/A until data in the reference cell

C

Colin

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

Pete_UK

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
 
J

JMB

check the match function

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

Colin

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.
 
Top