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 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. Show Drop down list auto populate with VLOOKUP function Drop down list auto populate with VLOOKUP functionPlease do as follows to auto populate other cells when selecting in drop down list. 1. Select a blank cell that you want to auto populate the corresponding value. 2. Copy and paste the below formula into into it, and then press the Enter key. =VLOOKUP(D2,A2:B8,2,FALSE) Note: In the formula, the D2 is the drop down list CELL, A2:B8 is the table range includes the lookup value and the results, and the number 2 indicates the column number which the results locate. For example, if the results locate in the third column of your table range, please change the 2 to 3. You can change the variable values in the formula based on your needs. 3. From now on, when you select a name in the drop down list, E2 will be auto-populated with a specific score. Easily select multiple items from drop-down list in Excel:Have you ever tried to select multiple items from a drop down list in Excel? Here the Multi-select Drop Down List utility of Kutools for Excel can help you easily select multiple items from the drop-down list in a range, current worksheet, current workbook or all workbooks. See below demo: Drop down list auto populate with Kutools for ExcelYou can easily populate other values based on drop-down list selection without remembering formulas with the Look for a value in list formula of Kutools for Excel. Before applying Kutools for Excel, please download and install it firstly. 1. Select a cell for locating the auto-populate value (says cell C10), and thenclick Kutools > Formula Helper > Formula Helper, see screenshot: 3. In the Formulas Helper dialog box, specify the arguments as follows:
Now the corresponding cell value will be auto-populated in cell C10 based on drop-down list selection. If you want to have a free trial ( 30-day) of this utility, please click to download it, and then go to apply the operation according above steps. Demo: Drop down list auto populate without remembering formulasRelated articles:Autocomplete when typing in Excel drop down list Create drop down list from another workbook in Excel Create a searchable drop down list in Excel How to create drop down list with multiple checkboxes in Excel? More tutorials for drop down list... The Best Office Productivity ToolsKutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
Read More... Free Download... Purchase... Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
Read More... Free Download... Purchase...
Say something here... symbols left. You are guest
or post as a guest, but your post won't be published automatically. Post Loading comment... The comment will be refreshed after 00:00.
Auto Populate Cells Based on Dropdown Box Selectionscott[emailprotected]June 5, 2018Excel Examples This post will guide you how to create a drop down list and how to auto fill cells in Excel based on a dependent drop down list. When selecting a value from the drop down list, then it should be able to populate the value in another corresponding cell. For examples, you have created a drop down list based on the values in range B2:B4, and when you select any value from the drop down list, the corresponding value in range c2:C4 should be populated in another cell automatically. What are These Functions?
Read on to learn more and discover how easy it is to use them. |