Correct reference error on cell

[avidcat]

I am getting a reference error on a few cells on my excel sheet.

I can't seem to figure out why I am getting this error, please see attached.

thanks for any help,
Nick

[pike]

you will have to zip that work book as its a little large for me

[martindwilson]

=IF(D3="","",INDEX(Exceptions,MATCH($B$3,Employee_Names,0),MATCH(D3,'Accounting Exceptions'!#REF!,0)))
what range is that bit in red?

[ncmay]

Is the number (254) correct at the end of your dynamic named range Exceptions?

Please Login or Register  to view this content.

[avidcat]

How do I view and edit the dynamic named range? Someone made this formula for me and I am not sure how to locate and edit that.

thanks,
Nick

[martindwilson]

id still sort out that bit in red first as thats where the errors are coming from
what is it supposed to do?
it looks for the value in d3 on 'Accounting Exceptions'! but where?

[avidcat]

I am not seeing that ref error in red, I see this:

=IF(D3="","",INDEX(Exceptions,MATCH($B$3,Employee_Names,0),MATCH(D3,'Accounting Exceptions'!$C$3:$ZZ$3,0)))

[avidcat]

I found it, on the Names Manager under the Formula's tab. I expanded that to a 1000 to handle future dates.

It now works.

[martindwilson]

i see now , col zz doesn't exist pre 2007!