Forum Discussion
Dynamic Dropdown List with Moving Target Column
I am looking to create a dynamic drop down menu that requires referencing a moving column. I can create a simple dynamic drop down menu using the below formula: =OFFSET ( ReferenceDEFINEDColumn...
I believe I can construct the formula for you if you attach your sample file with given data and expected results. Certainly, I won’t be using OFFSET for being volatile. I will be using INDEX, the most versatile function from my viewpoint.