Sir,
I have my present salary in Col-B and new (fitment range) salary in Col-C. If Col-B matches with any one of the fitment range cells of Col-C, new salary will be the present salary. Else, my new salary will be fit in the next higher cell of the fitment range. I want to show my new Salary in Co-D. How can I do? Should I use nestedif or vlookup or match? Please guide me with code. Thanks & regards.
<colgroup><col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:2486;width:51pt" width="68"> <col style="mso-width-source:userset;mso-width-alt:2816;width:58pt" width="77"> </colgroup><tbody>
</tbody>
I have my present salary in Col-B and new (fitment range) salary in Col-C. If Col-B matches with any one of the fitment range cells of Col-C, new salary will be the present salary. Else, my new salary will be fit in the next higher cell of the fitment range. I want to show my new Salary in Co-D. How can I do? Should I use nestedif or vlookup or match? Please guide me with code. Thanks & regards.
A | B | C | D |
Names | Salary | Fitment Range | New Salary |
AAA | 78976 | 69700 | |
BBB | 82626 | 71800 | |
CCC | 83114 | 74000 | |
DDD | 84759 | 76200 | |
EEE | 84964 | 78500 | |
FFF | 86789 | 80900 | |
GGG | 86789 | 83300 | |
HHH | 86789 | 85800 | |
III | 86866 | 88400 | |
JJJ | 88400 | 91100 | |
93800 | |||
96600 |
<colgroup><col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:2486;width:51pt" width="68"> <col style="mso-width-source:userset;mso-width-alt:2816;width:58pt" width="77"> </colgroup><tbody>
</tbody>