Video Tutorial: How to use the vlookup function in Excel

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 (http://camstudio.org)

Learn Everything There is to Know About Microsoft Excel

Advertisements

One comment

What do you think?

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s