Offset FunctionHelp

Occasional Contributor

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

@DarianLT 

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))

 

Previous post

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.