IF with INDEX function
I'm trying to elaborate a formula that only brings up a cell from a month of the year (ex: january) that is connected to the year we are at now (2023) and the year before (2022). So when we are in 2024, the cells of the months that come up are from the year 2024 and 2023, and etc. For this, I created a separate sheet, so this sheet in the image is just where the data is supposed to come from. I think I'll have to use the IF function and INDEX, but I don't know how.
Help Article Resources
Check out the Formula Handbook template!