Dec 07 2021 03:38 PM
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.
Dec 07 2021 04:11 PM - edited Dec 07 2021 04:13 PM
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))
Dec 08 2021 12:05 AM
Dec 08 2021 02:32 AM
Dec 08 2021 08:07 AM