motion2082
New Member
- Joined
- Jul 29, 2014
- Messages
- 4
RE: Please help make IFERROR work in Excel 2003
Hey guys,
Trying to get my Excel 2003 spreadsheet to accept the formula
https://www.dropbox.com/s/jrk5i3l8uu...-Example2.xlsx
It works in Excel 2011 but not 2003
Any ideas how to fix?
Hey guys,
Trying to get my Excel 2003 spreadsheet to accept the formula
Code:
[U][COLOR=#0000ff]=_xlfn.IFERROR(INDEX('CAMPUS LOCATION'!$E$2:$E$20,SMALL(IF(('CAMPUS LOCATION'!$B$2:$B$20=$B2)*('CAMPUS LOCATION'!$E$2:$E$20<$D2),ROW(E$2:$E$20),""),1)-1),"")[/COLOR][/U]
https://www.dropbox.com/s/jrk5i3l8uu...-Example2.xlsx
It works in Excel 2011 but not 2003
Any ideas how to fix?