User Profile
Syam4
Copper Contributor
Joined May 25, 2023
User Widgets
Recent Discussions
Re: Unable to create a dynamic and dependent dropdown!
Brilliant..! Thanks a lot Hans 🙂 Using the same logic I tried to connect between column 'Brand Name' and 'Item Name/Description' of sheet 'Material Register' which did NOT work.! I used the named range 'ItemList' for the same and below is the formula I used - =OFFSET(Lists!$AF$2, MATCH($C4, ItemList, 0), 0, COUNTIF(ItemList,$D4), 1) Could you please advice and help me fix this too.? Thanks in advance,1KViews0likes2CommentsUnable to create a dynamic and dependent dropdown!
Hello all, I have an excel workbook with two work sheets 'Material Register' and 'Lists'. Sheet 'Lists' has a table named 'MaterialData' which will capture name of supplier and brand names. in other sheet named 'Material Register' I have a table named 'MaterialRegister' where column 'Supplier Name' and 'Brand name' is available. My requirement is when I select a supplier name in the second sheet, column brand name should give me a dyanamic dropdown related to only selected supplier. The subject document shall be accessed from here - https://1drv.ms/x/s!AkJ6pkB78bcpi3pbYBxZJIHEP1gN?e=6b0SC2 Looking forward to support from this expert group.! Thank you,Solved1.1KViews0likes4Comments
Recent Blog Articles
No content to show