Create "DROPDOWN" list using "NAME MANAGER" option in Excel
Today let’s try “DROPDOWN LIST” function using “NAME MANAGER”.
We can name a particular range of cell with “NAME MANAGER” option
we have given a name “EMPLOYEE_LIST” to a range of cell containing employee names.
After that, we can use data validate function in excel to make it work.
Also, you can now use “VLOOKUP” function to determine the salary of a particular employee.
I have already uploaded “VLOOKUP” tutorial video, please check out my videos.