Match / Copy cell to current month column

Hi,

Looking to get a formula to return a cell value to another cell based on current month.

In the attached example;

B3 is current date
B4 is blank, enter any date to change date in B5
B5 will display date in B4 or if blank date in B3
B6 shows month from date in B5
B7 is user data to copy

I'm looking for a formula for D7:O7 that will return the value in B7 based on the month in B6, so if B6="Feb" then E7="70" or if B6="Aug" then K7="70", but at the same time not affecting other cells in range D7:O7

This is all to help me solve an a query I have in another post which I think is unachievable so I am trying different methods

https://www.excelforum.com/excel-for...her-sheet.html

If anyone has any ideas how I can solve this without VBA I would appreciate it

TIA

It sounds like you want to have a formula AND a value in each of those cells. You can't (without VBA).

The only workaround would be to use another row of cells to deliver the result:

=IF($B$6=D6,$B$7,D7)

copied across.