https://docs.google.com/spreadsheets/d/1Mplda1RRNa7NW9mrWxvi6qCbz6mABAqP/edit?usp=drivesdk&ouid=116089498010699794174&rtpof=true&sd=true
doing an xlookup and getting values from sheet2
the issue is that next quarter, the data will be in column L (F25Q2), quarter after that , F25Q3 (column N), etc.
ideally, if it's feasible, I want a lookup/sumifs to dynamically get the numbers based on the quarter and year (I do already have separate formulas to get me the quarter number
and year), so it's NOT dependent on guessing the column letter
doing an xlookup and getting values from sheet2
the issue is that next quarter, the data will be in column L (F25Q2), quarter after that , F25Q3 (column N), etc.
ideally, if it's feasible, I want a lookup/sumifs to dynamically get the numbers based on the quarter and year (I do already have separate formulas to get me the quarter number
and year), so it's NOT dependent on guessing the column letter