• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Match and Dropdown and suggest answer


New Member
My question is about sheet 3 in the file attached.

In the column, A (for example A4) when has a value then in column E / Article Number (eg E4) has a dropdown for selection matching to column A. and to do that I have used the formula

Now what I want to achieve is, in column A, say in cell A4 if I change the value then matching to that a new set of dropdown should appear in cell E4 matching the changed value in cell A4 for example. The Variant number should be populated from Sheet1!$B$2:$BF$2 and the drop-down should be matched as per sheet 1.

In short, if the user changes the Variant number in sheet 3 column A, the Article Number column E should also automatically change and give a new set of dropdown option matching the changed value of column A. Reference of values are in sheet 1.

Hopefully, I am not confusing.



Well-Known Member
Sheet3, E4 validation formula:
Copy down.