How to auto-populate other cells when selecting values in Excel drop-down list

Let’s say you have created a drop-down list based on values in range A2:A8. When selecting a value in the drop-down list, you want the corresponding values in range B2:B8 to be automatically populated in a specific cell. For example, when you select Natalia from the drop-down, the corresponding score of 40 will be populated in E2. This video provides a method to help you solve the problem.

[waqasarshad]

I am working to create an excel sheet for a specific purpose mainly covering some business details for me. Your video's topic may also be helpful for me, but I have another query. Can you please help me out? I have hardly found anything close so far.

For some entries in cells, I have used data validation (selected 'List' as validation criteria under 'Allow' tab of Data Validation window) for three options.

In addition to that, I have used Conditional Formatting, made a New Rule by selecting 'Use a formula to determine which cells to format' and used 'Format' button to fill the colors of cells.


The purpose is to identify the cells based on outcome and color of the formatted cell (e.g. Excellent, Good, Poor as three options in drop-down of a single cell).

For the purpose of sharing the information to other, I want to add the comments with each of the drop-down option. Is there a way that can be helpful to auto-populate separate comment based on drop-down selection of data validation options of a single cell?

[lilyt]

how to do it in vlookup? I tried but doesn't work :(