Hi all,
How can I refer to a range with INDIRECT without using VBA? The range I want to refer to is:
e.g.
where "CST" changes depending on the selection in my ComboBox.FY18_JPN_DTC_CST
SUMIFS(INDIRECT("FY18_JPN_DTC_"&Selected_Metric),Category,"PANT",Attribute,"BLUE"))
Bookmarks