How to auto populate other cells when selecting values in Excel?

Let’s say you have created a drop down list based on values in range A2:A8. When selecting 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 40 will be populated in E2 as the below screenshot shown. This tutorial provides two methods to help you solve the problem.
You can follow the step-by-step guide via the following hyperlink: