Forum Discussion
Index Match with IF statement
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, In...
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.