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, 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.
5 Replies
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.
