Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISERROR and INDEX Funcion question | Excel Worksheet Functions | |||
if(iserror()) question | Excel Worksheet Functions | |||
IF(ISNA.. or ISERROR? question.. | Excel Discussion (Misc queries) | |||
Iserror question | Excel Worksheet Functions | |||
Another ISERROR question... | Excel Programming |