Problem: I have a Dropdown list that displays a range based on the selection in the first drop down list. I am using the indirect function in the 2nd drop down list to look up a named range - when I use the indirect function to reference a dynamic range (using the offset function) it doesn't...
Hi all; I could use some Excel Ninja help here. I have scoured the blog, digested dynamic ranges with offset formulas and tables, and pretty much bled my eyes out in excel for about two days and this website looking for a solution and haven't found it (I'm so close!).
Goal: Create a Graph...