Learn more about using VLookup in Excel with this 3 Part Video Tutorial Series. This covers exact and approximate lookup, as well as best practices. Download sample file to follow along.
1. Vlookup with Exact Match in Excel
What is covered in this Excel tutorial:
1. What is Vlookup and what does it do?
2. How to use Vlookup to find a value. The different parameters to set up for the Vlookup function
3. Different examples of using the function
4. Variations of VLookup formula like from a different workbook, working with a named range and more.
2. Vlookup with Approximate Match
What is covered in this Excel tutorial:
1. Difference between Exact and Approximate Match in VLookup
2. How to use the Approximate match function
1. Vlookup with Exact Match in Excel
Learn best practices when using Vlookup function in Excel. This will ensure you get the results you expect from the Excel function.
What is covered in this Excel tutorial:
1. Vlookup issues when table array doesn't have unique values in the first column
2. How to make it easy to Copy Vlookup formula across cells
3. An important consideration of lookup value
These tutorials videos are created by Ramgopal in Excel 2016 for Office 365. You can follow them in other versions of Excel as well.
If you found these tutorials useful, please share with your friends!