![]() ![]() Select the range of cell E9:E12 as the source of the dropdown list.Then from the first dropdown list, select List.In the next dialog box, go to the Settings tab.And then select cell F4 and then go to Data tab > Data tools > Data Validation.In the next Remove Duplicate dialog box, make sure that Column E is checked.In that message box, select Continue with the current selection.Then a warning window like the below image will pop up.Then select the range of cell E5:E12 and then go to Data tab > Data Tools group > Remove duplicate.In order to create a drop-down list, we first need to copy the salesman’s name to the right side of the sheet.Each person’s name would be stored in a dropdown menu.We now want to get the sales value of each person.We have the sales record of each salesperson.Using the combination of VLOOKUP, INDEX, MATCH, SMALL IF, IFERROR, and ROW, we can form a formula that can help us to return multiple values from the dataset according to the values stored in a drop-down list. Vlookup Multiple Values Combining INDEX, MATCH & ROW Functions For avoiding any version or compatibility issues, try to use the Excel 365 version.ġ. A vast array of formulas is going to be used here. We are going to present two methods of how you can use the drop-down with the conjunction of the VLOOKUP function to return multiple values. Vlookup Return Multiple Values in Drop Down Lists.xlsxĢ Easy Ways to Vlookup and Return Multiple Values in Drop Down List ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |