vlookup with drop down mac excel 2013 all same response

➤ In the Allow box, select the List option. You’ll find a dialogue box named Data Validation. ➤ Choose the Data Validation command from the Data Tools drop-down under the Data tab. Read More: VLOOKUP Partial Text from a Single Cell in ExcelĪfter defining the range of cells (C5:C13) with a name, we have to set up the drop-down lists for salesman and month names. In our example, we have defined the range of cells with the name: ‘Salesman’.

➤ In the Name Box, situated at the top-left corner, give a name to the selected range of cells. ➤ Select the range of cells B5:B13 first. To do this, we have to follow two simple steps as stated below: Now let’s define the range of cells containing the names of salesmen. Step 2: Defining Range of Cells with a Name Read More: Use VLOOKUP with Multiple Criteria in Excel (6 Methods + Alternatives) So, in C15 and C16 cells, we have to assign the drop-down criteria for salesmen and months.Īnd in the output Cell C17, we’ll insert the VLOOKUP function to extract the number of sales for a particular salesman in a particular month. There’s another table at the bottom where the salesman and month names have to be chosen from the drop-down lists.

In the following picture, a random dataset is present where the amounts of sales for some salespersons have been recorded based on months. To use the VLOOKUP function with the drop-down lists, first of all, we need a dataset. How to Create a Drop Down List and Use VLOOKUP Step 1: Creating a Data Table

Vlookup with drop down mac excel 2013 all same response