I’m stumped.
Bottom Line Up Front: I used a formula for one array that worked. I copied formula and changed relevant details to the new array but it does not work.
INDEX MATCH formula that works is from F32-F280.
=INDEX($A$2:$AN$29,MATCH(C32,$A$2:$A$29,0),MATCH(D32,$A$2:$AN$2,0))
INDEX MATCH formula that does not work:
=INDEX($AQ$2:$BO$30,MATCH(C32,$AQ$2:$BO$2,0),MATCH(L32,$AQ$2:$AQ$30,0))
The working formula indexes:
~Pay Grades from row A2-A29 and
~Years working from B2-AN2
~And produces the Base Pay (BP) of the employee in F32-F280.
The non-working formula indexes:
~Pay Grades from row AQ2-BO2 and
~City where housing allowance is calculated from AQ2-AQ30
It does not work as it keeps producing the wrong amount.
I have no idea what I did wrong so thank you for your tiime.
Bookmarks