Forum Discussion
Index Match with IF statement
That's difficult to visualize. Could you attach a sample workbook with an indication of what you want?
HansVogelaarI 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.
See the attached version.
HansVogelaar 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.
I don't understand, sorry.