Forum Discussion
Excel Drop Down with Formulas
I have a raw data sheet that contains around 60 items and some of them could be duplicate items, but different lots. I would like to use an XLOOKUP to lookup the item number from the raw data and return any of the lot numbers into a drop down list in column B below. Then when I choose one of those lot numbers from the drop down, the cells on the right for quantity, expiration date, description etc. will populate based on what lot number I chose in the drop down in column B.
Can you post, instead of an image (from which I would still have to create my own version in order to create and test a solution)...can you post a copy of the actual spreadsheet (or a representative sample of it)? Put it on OneDrive or GoogleDrive with a link pasted here that grants access to it.
Alternatively, if you like solving your own problems, perhaps you could figure out the creation of a dynamic (changing) dropdown from the attached sample of Cascading Dropdown. This video regarding Dynamic Array functions might also be useful.