Match or nested if or vlookup?

[PKBrahma]

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.

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>

 

[PKBrahma]

Sir,
I owe you very much. I just couldn't find out the logic and so failed. Till now, I am just copying the codes given by you. Can't I write by myself? Of course, not. Because, I've been teaching English literature for 34 years now. I am not an expert in Excel. Anyway, you are inspiring me to write by myself. Me be blessed. Thanks and regards. Bye.

 

[Aladin Akyurek]

@ PKBrahma

You are very welcome. Teaching literature is a great job.

 

[Nishant94]

Sir,
Even if the value of a cell in Col-B matches the value of a cell in col-D, then also the value should change to next value. In that case, what to change and where? Please advise. Thanks.

You can also use this:

=IF(B2="","",INDEX($C$2:$C$13,MATCH(B2,$C$2:$C$13,1)+1))