Stop #N/A until data in the reference cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I keep cells blank (that have vlookup function in) until there is
data in the cell being referenced
 
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
 
check the match function

=IF(ISNA(MATCH(arg1, arg2, arg3)), "", VLOOKUP(arg1, arg2, arg3, arg4))
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use & with two formulas 2
Turning N/A cells to blank Cells 4
HELP!!!!!!!!! 2
Pivot Table with Data Model Connection - getpivotdata reference issue 0
#N/A In Cells 7
Avoid counting #N/A filled cells, or avoiding #N/A altogether 5
Help with dynamic array lookup based on a single reference cell .. 2
Set add function ignore #N/A 1

Back
Top