-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
if(iserror
-
K
multiple index(match with ISERROR
Hello, I have a multiple index(match that works but I would like to add an IF(ERROR on the first condition so that I can eliminate the #NAs . INDEX('HOA-HOS'!$E$8:$E$12508,MATCH('3.Claim Line Detail O vs F'!$S4,'HOA-HOS'!$B$8:$B$12508,0))*INDEX('FS INFLATORS'!$D$2:$D$3,MATCH('3.Claim Line...- Kmitchell
- Thread
- if(iserror indexmatch line multiple multiple index(match
- Replies: 1
- Forum: Excel Questions
-
I
Searching and replacing "- "
I have a worksheet that contains 900 rows of text data. In the column some of the text starts with a hyphen and space "- ". The others start with a number or alphabets. I am trying to compare this column to another one and find matches between them using IF(ISERROR(MATCH. I followed the thread...- izhassan
- Thread
- excel search if(iserror regular expressions
- Replies: 11
- Forum: Excel Questions
-
T
if(iserr) question
=IF(AD36<=12,((AD$24*AN36)/AN36),AD36),IF(AD36=0,0) how do i use the if iserr in this. it works when i have a number in cell AD36, bout it won't work when cell AD36=0?? AD=11 (which i have to make the min to be 12), and if AD36=0, then i want the result to be 0 please help!!!- tmiao
- Thread
- if(iserror
- Replies: 1
- Forum: Excel Questions
-
J
Opposite of ISNA Function
I often need a formula to not return an error value (e.g., "#NA") because it throws off my formulas and pivot tables, so I often find myself throwing an "IF(ISNA" into my formulas to return a custom value or to do another formula in the case of an error otherwise being returned. But when I have...- jeffgibson55
- Thread
- error values if(iserr if(iserror if(isna if(true
- Replies: 4
- Forum: Excel Questions
