Jan 25 2022 03:07 AM
I'm trying to use INDEX MATCH to fill in values in column H.
I'm trying to write a formula which IF column G = "Forecast" (Index(match forecast from meterage tab) then multiply by 0.9341, IF NOT, Index match into master sheet for Budget/Actual figures)
I want it to sum up the rows in meterage tab in columns H, I and J.
In Master I need the figures from column AD.
Jan 25 2022 03:11 AM
That's difficult to visualize. Could you attach a sample workbook with an indication of what you want?
Jan 25 2022 03:20 AM
@Hans VogelaarI have attached the workbooks I'm trying to write the formula in BFA Tables file, Policy-Non Policy Tab Column G.
I want to pull the data from the meterage Tab to get the sum of Rows for column G, H and P.
Jan 25 2022 03:53 AM
See the attached version.
Jan 25 2022 04:18 AM
@Hans Vogelaar Apologies if I did not explain properly.
I'm trying to fill in values in column G
The formula should be based on IF column G = "Forecast" (Index(match forecast from meterage tab) this would be a sum of the rows. then multiply by 0.9341
If "Forecast" is not found its should look in master sheet in column AD for "Budget" and "Actuals" figures, and brig these figures as they are.