Forum Discussion
Offset FunctionHelp
I am doing an Offset function to predict analysis for this set of data. I am having an issue using the match with the offset function. I need to match it with the strong, base, and weak case scenario while pulling the column/row with the predictive percentages. I have a formula and tried it a couple of times but keep receiving N/A.
4 Replies
Like your previous post, you need to inform Years (plural) instead year(singular).
=INDEX(Total_Revenue,MATCH(1,($I$4=Ticker_Symbol)*(I$5=Years),0))- For the offest function on the forecast tab I was not matching to a year yet. I think I may be having a separate error.
- There is no formula in the "Forecast Statement" tab/sheet.
The formula I mentioned is in the "P&L Statment" sheet.
