I use the values A, B, C in a drop-down list. Each value corresponds to a code: 111,222,333 When I select the DROP-down list (A,B,C) I want the corresponding value to be displayed (example: Select B and 222 should appear, select C and 333 should appear etc. How can I make this selection? Would you be kind enough to answer?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
I have a question about the DROP-DOWN list.
0
Answers
0
Selected Answer
Hi there! It seems like you want to use a VLOOKUP function or INDEX/MATCH lookup in another cell to get the data you want.
Here is an example:
=VLOOKUP(A1,D1:E3,2,FALSE)A1 would be the cell with the drop down menu.
D1:E3 would be the table where you have A in D1 and 111 in E1 and B in D2 and 222 in E2, etc.
Update:
Try this for your file:
=VLOOKUP(C1,C7:D9,2,FALSE)If that doesn't work, please try to explain in more detail what you are doing. Your worksheet is using overly complex ways to do simple things. I didn't offer suggestions to change it because I thought that maybe it is part of a larger file and it has to be like that.
0
1. the solution does not meet the wishes.
I can't define A1, it's selected from the COMBO LIST
the solution you propose is inconvenient
2. How can I change the font in COMBO-LIST?
Discussion
Hi, please click the edit button for your original question and upload your sample file there. Also, if you can, try to post the question in english. I updated my answer with the formula that I think you are asking for based on your sample file.
don (rep: 1989) Aug 25, '20 at 3:10 pm