Options for IFNA or IFERROR in Excel 2003

[joelnichols]

What is the best option for errors using Excel 2003. IFNA and IFERROR don't work it seems. Just threw this together till I found something better. Quite a mouthful eh?

=IF(ISERROR(INDEX('RH Report'!$E$1:$E$2135,MATCH(A15,'RH Report'!$D$1:$D$2135,0),1))," ",(INDEX('RH Report'!$E$1:$E$2135,MATCH(A15,'RH Report'!$D$1:$D$2135,0),1))).

 

[awoohaw]

as far as I know this is the only way until the IFERROR and IFNA FUNCTIONS were created.

=IF(ISERROR(expression,"",expression)
=IF(ISNA(expression,"",expression)

 

[joelnichols]

Guess I have to shop for a newer version. Just a little behind the times.
Thanks.