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...
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.- Hey can you check f15 in the forcast statement tab I was able to fix the P&L Statement.
