Another ISERROR question...
Adam -
I understand perfectly since I am also at the "swearing & throwing things"
stage. However:
First: it looks as tho your second IF is looking for a space character
rather than an empty cell - they're different. Have you tried something
like
IF(ISNUMBER(L9), L9/$K$5, "")
Then if there's a real live number in L9, you should get what you want;
otherwise, nothing in the cell.
Second: do you really want all of the $ signs in your first formula?
Because it's always looking up the same info?
Third: you probably want the newsgrp called worksheet.functions since it
looks like that's where you are in your Excelling -
Good luck -hopes this helps at least a little bit -
"Adam" wrote in message
om...
Allright this is what I am trying to do....
I have a small, one page database that is on a sheet called "crap".
On the next page (sheet 3) I am trying to recall the information that
I have typed into the database located on sheet "crap".
Allright, On sheet 3 (column "L") this is the formula that I am using
to recall some select information from sheet "crap"...:
=IF(ISERROR(MATCH(A9,crap!$A$5:$A$152,0)),"",VLOOK UP(A9,crap!$A$5:$M$152,3,0
))
(basically I type in a name in A9 and it pulls the corresponding
information and puts into that cell)
I know I know this is pretty basic stuff for most of you but it took
me a little while to figure it out...:)
The formula is working great...however, in another cell (column "M") I
have set the function (I stole the proceeding function from another
worksheet, so far much of my excel stuff has been stolen from here or
other places...I know I'm lame):
=IF(L9=" ","",L9/$K$5)
This works as long as the previous function brings up a number...if it
does not then I get the dreaded "#value". (sometimes the information
in that cell says "NA" and that is when it all hits the fan!)
I need a formula to go into column "M" that will basically leave
everything alone if the above "iserror" formula turns up "NA" (or
anything that is not a value)
I looked at possibly using something like this:
=IF(ISERROR(YourFormula),"";YourFormula)
but so far I have not been able to understand how to get it to work.
I am pretty new at this stuff so I appreciate any help you all might
have. I am also open to any websites or books that might be able to
help me along with this Excel stuff..:)
thanks,
Adam
p.s. I am sure that was not as clear as it would be from someone who
knew what the heck they were talking about, If I have left anything
important out I will be happy to add it.
|