joelnichols
Active Member
- Joined
- Apr 13, 2004
- Messages
- 406
- Office Version
- 2003 or older
- Platform
- Windows
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))).
=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))).