lookup

  • Thread starter Thread starter frank
  • Start date Start date
F

frank

I am performing a lookup function but in certain
situations the cell that is looked at is blank. Is there
a way to avoid getting the #N/A as the result?

thanks
 
frank,

=IF(ISNA(yourlookup),0,yourlookup)
Is the basic construct of testing for the #N/A and if your Vlookup would
result
in #N/A then return a zero (can be changed to a blank by substituting two
double quotes
for the 0)

John
 
Franh,

Go to a cell that has a "looked-up value" of #n/a.

Select the "Fx" button.

Move your cursor through the formula and watch where the
sub-formulas break down to #N/A.

Most likely you will find that there is a miss-match in
data. Meaning 991000 (as text) is not the same as 991000
is as a number even though it looks the same on the
screen.

To answer your question more specifically, I nned more
information.

HTH
Dennis
 
Try the ISNA command
It would look like this
=ISNA(lookup(lookup value, array)=True," ",lookup(lookup
value, array)
This should return a blank cell in place of your #N/A
 
Back
Top