Solved Adding ISERROR to statement

Dell INSPIRON 1525
June 18, 2013 at 01:00:00
Specs: Windows 7, 2.128 GHz / 1014 MB
Does anybody know how to incorporate ISERROR into the following statement?

=INDEX('Unique'!$X$5:$X$13300,MATCH(DQ1393,'Unique'!$X$5:$X$13300,0))

This returns #N/A correctly but to make the system work in the next col I am adding =IF(ISERROR(T1393),"",T1393)

Thanks


See More: Adding ISERROR to statement

Report •

#1
June 18, 2013 at 04:25:03
✔ Best Answer
I can't test this right now, but typically you would wrap an ISNA function around your formula. I might not have all of the parenthesis right...

=IF(ISNA(
INDEX('Unique'!$X$5:$X$13300,MATCH(DQ1393,'Unique'!$X$5:$X$13300,0))),"",
INDEX('Unique'!$X$5:$X$13300,MATCH(DQ1393,'Unique'!$X$5:$X$13300,0)))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
June 18, 2013 at 06:18:37
Perfect ISNA Solution Checking for the error at the same time is going to save me about 10 columns of =IF(ISERROR(S599),"",S599)

Thanks


Report •
Related Solutions


Ask Question