H
HR Gal
I have a worksheet that I need help with.
What I am trying to accomplish:
J7=range/step - this refers to salary (range/step table is on seperate
worksheet)
L7=annual salary (would like this to update based on the J7 cell when it
changes, ie; if range/step is 65-01 it displays the annual salary for 65-01.
if you change it to 65-05 it should display annual salary for 65-05
automatically)
Can anyone advise how to accomplish this? Thank you in advance.
What I am trying to accomplish:
J7=range/step - this refers to salary (range/step table is on seperate
worksheet)
L7=annual salary (would like this to update based on the J7 cell when it
changes, ie; if range/step is 65-01 it displays the annual salary for 65-01.
if you change it to 65-05 it should display annual salary for 65-05
automatically)
Can anyone advise how to accomplish this? Thank you in advance.