Hi forum,

I need help with using the INDIRECT formula. I really can't figure out how it works just by following some tutorials. I need help on my specific problem.

My workbook has Sheet1 and Sheet2;
On Sheet1 I have many named ranges and they all refer to the entire workbook as their scope;
Namely, I have the named range "SALES_CATEGORY" on A1:A3 with "BUSINESS_1" and "BUSINESS_2" values inside it, and I have the named ranges "BUSINESS_1" and "BUSINESS_2" on B1:B5 and B6:B10 respectively with "SKU_1", "SKU_2" and "SKU_3" inside them, doesn't matter which ones exactly.

Now here comes the part that I'm currently struggling with.

On Sheet2 I want to use the Indirect formula, in cell A1 for instance, to find me the values inside "SALES CATEGORY" named range based on the text inside cell B1 (this text will be either SKU_1, SKU_2 or SKU_3, which refers to either BUSINESS_1 or BUSINESS_2 named ranges, so the latter are the values I want to get to depending on being SKU 1, 2 or 3). I probably repeated myself there a few times, but whatever.

Maybe it's not even the Indirect formula I need here, I really don't know and it's giving me headaches already! Can anyone give me a hand here?

Thanks!!