Скачать или смотреть How to Create a List Box in Excel - With the Vlookup Formula

Learn: The Quick & easy way How to create a list box in excel - How to use a list box in excel with the Vlookup formula

In this video, you will learn:
1. How to create a list box in excel
2. How to use a list box in excel with the Vlookup formula

In my last video tutorial, I talked about How to Insert Scrollbar in excel.
In today's video tutorial I am going to teach you How to Create a List Box in Excel and How to Use a List Box in Excel with Vlookup Formula
List Box in excel is used to create a list inside the box and choose them as we select the values from dropdown. List boxes are available in the Insert option in the Developer menu tab. We can use List boxes with VBA macro and also excel cells. Whatever values we select can be seen in the list box, and once we select any value that will be reflected, the cell linked to List Box.
List Box is located under Developer Tab in Excel. If you are not a VBA macro user, you may not see this DEVELOPER tab in your excel.
If the Developer tab is not showing, then follow these steps to enable the Developer tab.
• Go to the FILE option (top of the left-hand side of the excel).
• Now go to Options.
• Go to Custom Ribbon and click on the Developer tab check-box.
• Once the Developer Tab is enabled, you can see it on your excel ribbon.

How to Create List box in Excel
Firstly, I have created a month list in column A from A1 to A12.
Now, Follow the steps to insert the List box in excel.
Step 1:
Go to Developer Tab, Controls Section, Insert, Form Controls, then you will see a List Box symbol at the right-side corner of the Form Control Section
Step 2: Click on the List Box and draw a list box anywhere near the data set created within the worksheet. After that, Right-click on the List Box and select the option Format Control.
Step 3: Once you have selected Format Control, it will open a dialog box; go to the Control tab.
In the input, range select the month lists from A1 to A12.
In the cell link, select cell B1, to give a link for our output result, then click OK
We have linked our cell to B1. Once the first value in the List Box (i.e. January) has been selected cell B1 will show 1. Similarly, if you select March in the list box, it will show 3 in cell B1 in the Month List created.
HOW TO USE LIST BOX IN EXCEL WITH VLOOKUP FORMULA
Here is another example data table set I have created in table 2 below on how to use List Box in Excel with Vlookup Formula
Now we will look at the way of using List Box in excel.

Steps on how to use VLOOKUP in Excel

1. Click the cell where you want the VLOOKUP formula to be calculated. In my own case, I will pick Cell i18 where I want the Basic Pay Salary result to come out.
2. Go to "Formula Tab" at the top of the screen.
3. Locate "Lookup & Reference" on the Ribbon.
4. Dig out "VLOOKUP" at the bottom of the drop-down menu. This opens up our Function Argument Window where we are going to perform those conditions
5. In the LOOKUP_VALUE box, here you have to specify the cell in which you will enter the value whose data you're looking for. In this sense, I want the result from Month No in the cell i17 to display in cell i18 which the Basic Pay


……………………………………………………………………………………………………………………….
Share this video:    • How to Create a List Box in Excel - With t...  

For more simple and easy to follow How to videos,

Click the Link Below to subscribe:
   / @learnexcelwitht  

Join this channel to get access to perks:

   / @learnexcelwitht  

#listboxexcel #dropdownlist #vlookupfunction

LearnexcelwithT