Microsoft Excel 2016 Vlookup Tutorial

Vlookupb2c2e73true in this example b2 is the first argumentan element of data that the function needs to work.

Microsoft excel 2016 vlookup tutorial. Vlookup v stands for vertical is an in built function in excel which allows establishing a relationship between different columns of excel. Microsoft excel 2016 is the spreadsheet application in the ms office 2016 suite. In this tutorial ill show you how to use vlookup in excel 2016. Approximate match 1true assumes the first column in the table is sorted either numerically or alphabetically and will then search for the closest value.

Download the excel file. But before we begin lets first review the elements of the vlookup function. Heres an example of how to use vlookup. Specifically ill review an example with the steps needed to apply a vlookup.

In this video i explain everything you need to know to get started with vlookup for excel. For this demonstration we will be starting from scratch so double click blank workbook. Opening microsoft excel 2016 windows 10 a menu will be displayed asking you which type of template you would like to create. For vlookup this first argument is the value that you want to find.

A logical value that specifies whether you want vlookup to find an approximate or an exact match. In other words it allows you to find look up a value from one column of data and returns its respective or corresponding value from another column. This argument can be a cell reference or a fixed value such as smith or 21000. Elements of the vlookup in excel 2016.