Vlookup Made Easy [How To Do Vlookup in Excel]

https://softtechtutorials.com/microsoft-office/excel/how-to-vlookup

Introduction 0:00 Easy Vlookup 0:45 Excel Vlookup different sheets 3:13 Fix the table array 4:42

Hello and welcome to this Vlookup Made Easy [How To Do Vlookup in Excel]. Vlookup might seem difficult at first but together we will see that it is actually quite easy to use and very powerful in certain situations. Vlookup remained the same in older versions of Excel so it doesn’t matter which version you use. In the video, I’m using Excel 2016. I will show two different ways to use Vlookup.

The first one is very easy and fast to use, the second one is a bit more challenging but still beginner-friendly.

We start off by analyzing the Vlookup function. The first argument is a lookup value, which is usually the first column, but it can also be a single cell. The second argument is a table array. You can see this as a range or a group of cells. The third argument is the column index number. This number selects the column that will deliver the value in the Vlookup formula. The last argument is either True or false. Using true means that you match on approximate values. Using false means that you search on exact matches. A semicolon separates each value.

In the first method, we match a country with its correct currency by using the Vlookup function in a single cell. This cell requires input so you can manually adjust the cell to receive different results. This is a common use of Vlookup, which can save you a lot of time in big Excel sheets.

In the second method, we use Vlookup to grab information from a different sheet. After creating the formula, we drag it down across the column to copy the formula. Our vlookup doesn’t work for every cell as the table arrays range moves down as well. We can use $ signs in the table array to make this a fixed value. For instance, fixing a table arrays looks like this: $A$1:$E$16.

Keep in mind that this function isn’t amazing when you have a little amount of data but it gets incredibly powerful in big data files. Comments or feedback is more than welcome, as is subscribing to the channel. Hopefully, I see you in the next video. ... https://www.youtube.com/watch?v=_xjMehQL2eY