Fill multiple cells using a list
pilsweb
Posted messages
3
Status
Member
-
help-excel Posted messages 1 Status Member -
help-excel Posted messages 1 Status Member -
Hello,
After a few days of research on various forums and several tests, I am finally resolved to ask my question.
It has already been solved in a forum, but with a macro. Knowing little about Excel and having limited time, I wanted to know if there was a simpler way to solve my problem.
-I need to optimize (as best as possible) the data entry of a form in Excel 2010. So I have created drop-down lists for simplicity.
But how can I make it so that selecting a value from my drop-down list automatically fills in the cells below?
Explanation: In cell B7 I have my supplier drop-down list (about 30). And in B8 I have the address cell, B9 the city.
How, when selecting my supplier, can I automatically populate the other cells without using VBA? Are there formulas available?
I have done quite a few tests with functions, but nothing is working as I would like.
Could you help me?
Thank you
After a few days of research on various forums and several tests, I am finally resolved to ask my question.
It has already been solved in a forum, but with a macro. Knowing little about Excel and having limited time, I wanted to know if there was a simpler way to solve my problem.
-I need to optimize (as best as possible) the data entry of a form in Excel 2010. So I have created drop-down lists for simplicity.
But how can I make it so that selecting a value from my drop-down list automatically fills in the cells below?
Explanation: In cell B7 I have my supplier drop-down list (about 30). And in B8 I have the address cell, B9 the city.
How, when selecting my supplier, can I automatically populate the other cells without using VBA? Are there formulas available?
I have done quite a few tests with functions, but nothing is working as I would like.
Could you help me?
Thank you
3 answers
Hello,
I feel like I want to do the same thing, but on my side, I don't have the desired result. To be clear, my goal is as follows:
In column A I have a list of species of flowers (A1: SPECIES, and from A2 to A295, the names of all my species), and in column B their Family (B1: FAMILY, and from B2 to B295, the names of the corresponding families). Each species has a family, and families can group multiple species (I haven't merged the cells).
In Sheet 2, I would like to have a dropdown list offering all my species (I managed that), and for this selection to automatically fill the neighboring cell with the corresponding Family. I tried entering the following formula: =IF(ISBLANK(B8),"",VLOOKUP(B8,DATA,2,0)), but I only get a "0" in the targeted cell.
Can you help me understand the problem?
Fingers crossed that this first message works
See you soon and thank you in advance
I feel like I want to do the same thing, but on my side, I don't have the desired result. To be clear, my goal is as follows:
In column A I have a list of species of flowers (A1: SPECIES, and from A2 to A295, the names of all my species), and in column B their Family (B1: FAMILY, and from B2 to B295, the names of the corresponding families). Each species has a family, and families can group multiple species (I haven't merged the cells).
In Sheet 2, I would like to have a dropdown list offering all my species (I managed that), and for this selection to automatically fill the neighboring cell with the corresponding Family. I tried entering the following formula: =IF(ISBLANK(B8),"",VLOOKUP(B8,DATA,2,0)), but I only get a "0" in the targeted cell.
Can you help me understand the problem?
Fingers crossed that this first message works
See you soon and thank you in advance
