Index with match and (maybe) offset?

[Excellling]

Hi All,

I have been digging around trying to find previous answers for my question but haven't been too successful.

I am trying to do a fairly simple index match but I think I need an offset thrown in there also.

For the example data below, I would like to feed in Fruit and Orange and 2026 and have it return 97.

I seem ok with the first two but not sure how to use the row with year in my formula to return the correct column but also index/match the first two columns.

Any suggestions and to improve my understanding of formulas would be appreciated.

Thanks

 

[Peter_SSs]

You're welcome. Glad we could help. Thanks for the follow-up.