Ok, I see the issue, your named ranges in the formula are whole columns, you can't have whole column references with Array formulas in Excel 2003...
So you should then redefine the named ranges to a limited number of cells or use dynamic named ranges (i.e. change the Refers to field for FY11Commander to:
=OFFSET('Work Orders for FY11'!$H$1,1,0,COUNTA('Work Orders for FY11'!$B:$B)-1,1)
and change FY11RDaysOut to:
=OFFSET('Work Orders for FY11'!$F$1,1,0,COUNTA('Work Orders for FY11'!$B:$B)-1,1)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
That would make the whole formula
=IF(N11>0,INDEX(C:C,MATCH(1,(N11=OFFSET('Work Orders for FY11'!$F$1,1,0,COUNTA('Work Orders for FY11'!$B:$B)-1,1)*(J11=OFFSET('Work Orders for FY11'!$H$1,1,0,COUNTA('Work Orders for FY11'!$B:$B)-1,1)),0)),""))
It's telling me it is invalid. I'm sure there's a comma or something out of place. Do you see it?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks