May 09 2022 08:29 AM
Dear Excel Community,
I would appreciate your help with a problem i am trying to resolve.
Please see the attached sheet for example. Date base formula
So essentially i want to populate Column M (Current Forecast) with the corresponding data based on the month we are in. So if we are in May, i want May's data in Column M. When we hit June, i want June's data in Column M.
Hope someone can help me out :)
Thanks in advance
Raj
Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Current Forecast |
£100.00 | ||||||||||||
£200.00 | ||||||||||||
£50.00 | ||||||||||||
£40.00 | ||||||||||||
£12.00 | ||||||||||||
£200,000.00 | ||||||||||||
£100,000.00 | ||||||||||||
£0.00 | ||||||||||||
£300,402.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
May 09 2022 08:53 AM
May 09 2022 09:01 AM
May 09 2022 09:06 AM
May 09 2022 09:09 AM
May 09 2022 09:15 AM
SolutionMay 09 2022 09:24 AM
Jun 01 2022 05:39 AM
Jun 01 2022 07:14 AM
Jun 01 2022 08:05 AM
Jun 01 2022 08:32 AM
May 09 2022 09:15 AM
Solution