Automatically change cell based on date

Hi All,

I need some assistance in producing a formula. What I am trying to achieve is:

I have a data worksheet and a summary worksheet

The Data Worksheet will contain hundreds of account names with months running from Columns B - P containing pricing information

What I would like to do is, in the summary sheet enter a month next to the account when the price change occurs and for the Data sheet to update with this price and continue with it for the rest of the remaining months.

In the attached, I have managed to get the price change but can not get the months after to recognize that the price change has occurred.

I am sure there is a simple solution to this.

I have attached the sheet and highlighted in green the cells impacted.

Any help appreciated

Try

In B3

=INDEX(Summary!$G$2:$H$10,MATCH(Data!$A3,Summary!$A$2:$A$10,0),IF(Data!B$2 < Summary!$F2,1,2))

Copy across and down