Try
=IF(ISNA(LOOKUP(P12,S101:S105,T101:T105)),"",
(+K12-I12+1)*N12/LOOKUP(P12,S101:S105,T101:T105))
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"mollyk" wrote in message
...
I am relatively new to entering formulas in an excel spreadsheet. I am
trying to remove the '#N/A' error & can't get any of the solutions
suggested
to work. Here is my formula:
=((+K12-I12+1)*N12/LOOKUP(P12,S101:S105,T101:T105))
I cannot get the "IF(ISNA' to work. What am I missing?
Thank you.
"T. Valko" wrote:
You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"SayedMe" wrote in message
...
thank you ver much for your information realy helpful!!!
"T. Valko" wrote:
If you're using Excel 2007 try one of these:
=IFERROR(VLOOKUP(.....),"")
=IFERROR(VLOOKUP(.....),0)
Note those will trap *all* errors, not just #N/A.
--
Biff
Microsoft Excel MVP
"Ross" wrote in message
...
It worked fine using Excel 2007.
Thank you very much!
"T. Valko" wrote:
Try one of these:
Returns a blank:
=IF(ISNA(VLOOKUP(.....)),"",VLOOKUP(.....))
Returns a 0:
=IF(ISNA(VLOOKUP(.....)),0,VLOOKUP(.....))
--
Biff
Microsoft Excel MVP
"B. Franklin Saunders" <B. Franklin
wrote in message
...
I'm using vlookup in excel to pull select data from a worksheet.
The
problem
is that the value I'm seeking isn't always in the table array.
So,
I
get
a
#n/a error. The #n/a then prevents me from summing the data that
I'm
collecting using the vlookup. How do I make the #n/a go away or
equal
zero
so I can sum the data?