• 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

    Hui...

  • 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

Ayon

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
=XLOOKUP(A7;Sheet1!$B$2:$BF$2;Sheet1!$B$3:$B$20;;0;1)

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.
 

Attachments

  • Test_New.xlsx
    18.3 KB · Views: 7
Sheet3, E4 validation formula:
Code:
=INDEX(Sheet1!$B$3:$BH$11,0,MATCH(Sheet3!$A4,Sheet1!$B$2:$BH$2,0))
Copy down.
 
Back
Top