Hi,
I am trying to work out who in my data is eligible for a pay increment. I have a 2 column lookup table $A$2:$B$28 that shows Grade in Column A and Scale Point Ceiling in Column B
e.g.
Column A
GRADE
Column B
SCALE POINT CEILING
Administrator 10
I have thousands of employees and so doing individual IF & AND statements will take forever.
The IF Statement in my employee worksheet current works and is:
=IF(AND(I3<10,H3="Administrator"),"Due","Not Due")
So, if I3 is below 10 Scale Point then "Due" otherwise "Not Due".
I have thousands of people 20 plus grades, what is the best way to calculate this? I want to use my lookup table array $A$2:$B$28 on the other
worksheet as an IF & AND Array formula?
Any help will be much appreciated.
Andy
I am trying to work out who in my data is eligible for a pay increment. I have a 2 column lookup table $A$2:$B$28 that shows Grade in Column A and Scale Point Ceiling in Column B
e.g.
Column A
GRADE
Column B
SCALE POINT CEILING
Administrator 10
I have thousands of employees and so doing individual IF & AND statements will take forever.
The IF Statement in my employee worksheet current works and is:
=IF(AND(I3<10,H3="Administrator"),"Due","Not Due")
So, if I3 is below 10 Scale Point then "Due" otherwise "Not Due".
I have thousands of people 20 plus grades, what is the best way to calculate this? I want to use my lookup table array $A$2:$B$28 on the other
worksheet as an IF & AND Array formula?
Any help will be much appreciated.
Andy