How to find cell value depends on date and change it with specified value

[Bharat1965]

Basic Pay as on 31-12-2005	16140
			Date of MACP	1-Oct-06 18000
Month /Year	DUE		DRAWN	Differ-ence	Bill No. & Date
B.P. + GP	D.A.	HRA	Total		B.P. + GP	D.A.	HRA	Total
Jan-06	17140	0	-	17140		16140	0	-	16140	1000
Feb-06	17140	0	-	17140		16140	0	-	16140	1000
Mar-06	17140	0	-	17140		16140	0	-	16140	1000
Apr-06	17140	0	-	17140		16140	0	-	16140	1000
May-06	17140	0	-	17140		16140	0	-	16140	1000
Jun-06	17140	0	-	17140		16140	0	-	16140	1000
Jul-06	17660	353	-	18013		16630	333	-	16963	1050
Aug-06	17660	353	-	18013		17140	333	-	17473	540
Sep-06	17660	353	-	18013		17140	333	-	17473	540
Oct-06	17660	353	-	18013		17140	333	-	17473	540
Nov-06	17660	353	-	18013		17140	333	-	17473	540
Dec-06	17660	353	-	18013		17140	333	-	17473	540
Jan-07	17660	1060	-	18720		17140	1028	-	18168	552
Feb-07	17660	1060	-	18720		17140	1028	-	18168	552
Mar-07	17660	1060	-	18720		17140	1028	-	18168	552
Apr-07	17660	1060	-	18720		17140	1028	-	18168	552
May-07	17660	1060	-	18720		17140	1028	-	18168	552
Jun-07	17660	1060	-	18720		17140	1028	-	18168	552
Jul-07	18190	1637	-	19827		17660	1589	-	19249	578

<tbody>
</tbody>

I want to find data in 2nd cell as per the MACP date and change it to 20000 or other and the cell value change as per the date of MACP i.e date change the value of 2nd cell change automatically to 20000 or else.
Thanks in advance

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...solve-my-problem-post5080624.html#post5080624

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).