Forum Discussion
Excel Drop Down with Formulas
Hi,
I am trying to add drop downs to certain cells where the items populated in the drop down are based on a formula which pulls data from another sheet. Is this something that is possible and if so, how would I do that? My ultimate goal is to be able to choose a specific number from the formulas in these drop downs and based on that cell, the adjacent cells will populate their respective data with their respective formulas.
My ultimate goal is to be able to choose a specific number from the formulas in these drop downs and based on that cell, the adjacent cells will populate their respective data with their respective formulas.
Can you be more specific? Give a fleshed out example of what you're seeking. I think it's probably possible, because I've seen drop downs change dynamically based on prior entries. I'm just having a hard time visualizing the sequence you are desiring. Spell out a step or two, not of the solution (that's what you're asking us to come up with), but in English what will you be doing, what is the formula that will be in or connected to the drop down, what will it produce, what will the drop down look like? Stuff like that.
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.
