#How to use vlookup in excel youtube free

In this case, you could actually use Employee ID or Employee Name, as those are both unique values in your lists. So you need to choose the value in your initial list that will be used to lookup the value in your supervisor list.

lookup_value вЂ“ This is value you are going to use to вЂњconnectвЂќ the data.

LetвЂ™s go one by one through the criteria: Then, type =VLOOKUP and each of the criteria for the function will appear as shown below. The original Excel file is available here.ДЇirst, insert a new column and title it Supervisor.

#How to use vlookup in excel youtube free

You could manually plug in all of the supervisor names, but if you wanted to waste your time doing that, you wouldnвЂ™t be reading this article! Feel free to follow along with this example. You have another table that lists employee supervisor information, but itвЂ™s not connected to your current table.

LetвЂ™s get started with an example: imagine that you have two tables, one with your employee IDs, names, and sales information. Whatever the reason, VLOOKUP in Excel can help solve your data woes. Maybe your data always comes out separated, and you need to keep it together. Maybe your data comes from different sources. Fair enough! The briefest summary I can give is that VLOOKUP eliminates repetition by allowing you to easily combine sets of data. You might be wondering why VLOOKUP matters so much. ItвЂ™s hard to underestimate the importance of VLOOKUP, so I can say without exaggeration that VLOOKUP will change your (Excel) life.

If you want to go from novice user to highly-respected Excel office guru, VLOOKUP is the function you need to master. By Rich Rinaldi on Decemin Advanced Excel Functions and Formulas