Question about storing drop down list value

**swgary** · 01-04-2024, 12:41 AM

My question is, is it possible to store data from different drop-downlist option?
The situation is like this: I have a drop-down list containing option: A-1, A-2, A-3, A-4, A-5. Once I change the option in drop down list. The content of that sheet will also be changed, and there will be a value sum store into cell G2.
i want to store G2 value in another sheet call: Summary in cell B3. For example, when the drop-down list option is "A-1", the value is 5. and store into B3, when drop down list change to "A-2", it will then store into B4, but the value in B3 remain unchanged. Is it possible to finish this with excel formula?

**FDibbins** · 01-04-2024, 12:44 AM

There is nothing magical about a drop down (data validation), it acts in the exact same way as if you had entered the data manually, and excel formulas only see the data in the cell as if it had been entered manually.

The only real advantages of using a DD is that it saves typing, avoids typos/spelling mistakes, restricts entry to what you specify, and maybe saves a bit of time in entering data.
Other than that, no difference to manual entry

So, based on that, there is no (easy) way to save a DD selection.

Question about storing drop down list value

LinkBack

Thread Tools

Rate This Thread

Display

Question about storing drop down list value

Re: Question about storing drop down list value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Drop Down List Question

Drop down list question.

A Question about a drop down list

Drop Down List Question?

Drop down list question

[SOLVED] Drop Down List Question

[SOLVED] drop down list question

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions