Search results

That's it, thank you. I had tried searching but didn't come across the contextures link that you posted, and is also in the posts above. Thanks for the assist.

I did that. The indirect function on the data validation isn't working with a named range that uses an offset formula. That is the problem I'm trying to get around. The second drop down needs to be able to reference difference lists based on what's selected in the first drop down (works with...

I appreciate the post and learned something new, but that won't fix my problem. I'm familiar with using the Indirect function and can get the second drop down to load a correct data set in a non-dynamic capacity. I'm trying to get that 2nd drop down to become dynamic though so as lists of...

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...

Narayan, thanks. That was such a simple fix, but I didn't even think of it. Still learning about the more advanced functions. Really appreciate your help and the fast response. Hopefully I can return the favor in kind to someone else on the forum. For anybody else who looks at this post...

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...

Hi, my name is Dan - Logistics analyst for a fortune 50 company. Been scouring this blog for the last two days and have exponentially increased my excel awesome sauce arsenal. Keep up the great work PHD and forum Excel Ninjas.