After the Data Validation table appears, select Tab Settings, in the Allow section select List. You put your mouse in the first cell of the column of product code, then on the Data tab on the menu bar select Data Validation.Ģ. Now instead of typing each code one by one, it is very likely to be confused, you can apply the following method:ġ. The item code we will have to get from the list of goods, and the goods name, you can use the Vlookup function in Excel to reference projection out. useful.įor example, in the picture, TipsMake has a detailed list of sales invoices including product code, product name. For example, creating a dropdown list for customers to select the item, choose yes or no, the accountant chooses the item code, select a date from the list, etc., etc. This function is called creating a drop-down list by Data validation, it will provide a lot of utilities for us in the working process.
It will be very convenient, faster and more accurate.
#HOW TO USE VLOOKUP IN EXCEL WITH DROP DOWN LIST MAC HOW TO#
Therefore, within the framework of today's article, TipsMake will guide you how to create drop down lists - drop down lists to select data in excel. In the process of working, accountants have to enter a lot of data, especially those who do warehouse, when entering the detailed sales list, you will have to type each item, so it takes time, sometimes Left many mistakes.
0 kommentar(er)
