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...
That's difficult to visualize. Could you attach a sample workbook with an indication of what you want?