If in current month, don't use growth data, otherwise use month in date plus one one month's growth data for relevant country

losincog

New Member
Joined
Aug 19, 2020
Messages
10
Office Version
  1. 365
Platform
  1. Windows
Hi

I have a forecast from August '20 til August '21 but I would like to times the existing data by the percentage growth for the relevant country and fiscal period. Country (col A, A6 downwards)) and fiscal period (row 5 (E5 and onwards)):
Forecast.JPG
.

I have the growth assumptions in a separate tab called "Assumptions" - as you can see Fiscal Period is in row 9 and Country is in column A:

Budget Growth.JPG


1) I want it to pick up next month's growth data, rather than what month we are looking in the forecast. So for example, if the forecast is for October 2020 (Fiscal Period 2020P11), I want it to use the growth data for Fiscal Period 2020P12.

2) If the forecast is in the current month we are in, I don't want it to use the growth data at all. So we are in August now, I don't want it to use growth data at all. Only in future months.

Hope that makes sense!

Thanks
 
Last edited:

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Watch MrExcel Video

Forum statistics

Threads
1,127,093
Messages
5,622,666
Members
415,917
Latest member
kungsleden

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top