Dell INSPIRON 1525

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

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.

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

Ask Your Question

Weekly Poll

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History