Here’s a video tutorial I created to demonstrate how to use the vlookup function in Excel.  Excel 2010 was used, however this function works very similarly in most versions of Excel.

Download Microsoft Excel Now

The vlookup function allows a user to find data that matches a field in a spreadsheet. In this example, we look up fictional employee numbers based upon employee first and last name.

Also shown is two ways to copy the formula to several other cells by dragging or copy and pasting.

Video created using Cam Studio (

Learn Everything There is to Know About Microsoft Excel