Microsoft Excel VLOOKUP Tutorial for Beginners – Office Excel 2003, 2007, 2010

This video is a brief tutorial on how to use the (sometimes complex) =vlookup() function in Microsoft Excel. I use Excel 2007 in this video, but it works in 2003, 2007, and 2010. The tutorial is designed for beginners that are required to use Excel on a regular basis (probably for work). Some possible uses include: Catalog management, Simplification of a worksheet or workbook, or finding pricing, naming, or anything else out of a long list.
Video Tutorial Rating: 4 / 5

Don’t forget to check out our other video tutorials or share this video with a friend.

0 votes

Loading... 3,242 views

12 responses to “Microsoft Excel VLOOKUP Tutorial for Beginners – Office Excel 2003, 2007, 2010”

1. MrMonkeyboy1501 says:

   21/07/2012 at 9:54 pm

   Thanks for this very useful and clearly explained keep up the good work 🙂

   Reply
2. MEvans2703 says:

   21/07/2012 at 10:08 pm

   By “column 2” he means the second column of the data set. In this video, that translates to column B. However, if the data was shifted one column over (so nothing in column A) then “column 2” actually becomes column C.

   Do not pay attention to the alphabetical column number a column has, just where it is in relation to the total data set.

   Reply
3. Aniik0 says:

   21/07/2012 at 11:07 pm

   Hi can you clarify please. Several times when you did Vlook up you state you are going to select “column 2” but in actuality, 2 is a row…. Alphabets are Columns numbers are rows. that just made it a tad confusing cus i was looking for Column 2 as if i had lost my mind.

   Reply
4. Jon Flynn says:

   21/07/2012 at 11:24 pm

   Yes!

   Reply
5. bachelor3000 says:

   22/07/2012 at 12:02 am

   Awesome vid….one question: by using the term “anchor”, are you referring to setting absolute values ($) in the formulas?

   Reply
6. East17au says:

   22/07/2012 at 12:12 am

   thanks for the video, tho am looking for one that deals with 2 different spread sheets.

   Reply
7. cbgmtl says:

   22/07/2012 at 12:35 am

   Very instructive, thanks

   Reply
8. BSKseeker says:

   22/07/2012 at 1:23 am

   Can I just say, you have taught me better than my professors have at uni in 7 minutes, than they have in about 2 weeks.

   Reply
9. paterick4o8 says:

   22/07/2012 at 1:41 am

   worked for me, thanks!

   Reply
10. mpattuj says:

    22/07/2012 at 2:14 am

    was very hekpful, thanks a ton

    Reply
11. ShonniePooh73 says:

    22/07/2012 at 2:51 am

    Thank you a billion times over! This was very useful

    Reply
12. marlennegrl says:

    22/07/2012 at 3:07 am

    Great tutorial! Thank you!

    Reply