Hello,
I am looking for a formula that combines an INDIRECT function (references a different worksheet) and a MATCH/INDEX function.
My Master sheet has the INDIRECT reference (January, February or March). Each sheet with month names has Match function with desired sequence order. All I want to do is select a month on Master that would automatically go to that sheet and INDEX data based on MATCHed row.
I want to avoid unnecessary help columns to reduce formulas (workbook is already too big).
My Master sheet has the desired result (in yellow) based on the reference month.
Thanks
Bookmarks