Question

auto populate cells in excel based on another cell

Answer 1

Let’s say you have created a drop down list based on the values in cell range B8:B14. When you selecting any value in the drop down list, you want the corresponding values in cell range C8:C14 be automatically populated in a selected cell. For example, when you select Lucy in the drop down list, it will auto populate a score 88 in cell D16. See screenshot shows below.

For getting the result as above screenshot shows, you need the VLOOKUP function. In this tutorial, we will show you how to use the VLOOKUP function to auto populate other cells when selecting values in Excel drop down list.