Hi All,
I've attached a quick example worksheet to assist with my question. I am trying to write an index/match formula that can evaluate vertical and multiple horizontal variables.
In Sheet1, cell B6, I would like to pull the corresponding code from the "CF3" tab and match it to the correct fiscal year. As the data pull has a bunch of columns that come in, I need it to look at a few rows of data to grab the right one. Here is the row criteria it needs to match with:
Row 5 - Will always match the fiscal year. In this example "FY24".
Row 6 - Will always say "YearTotal" - no variable/cell to match with, it will always be this.
Row 8 - Will always be "Working" - no variable/cell to match with, will always be this.
Thanks for your help!
Bookmarks