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

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.

1 Star2 Stars3 Stars4 Stars5 Stars 0 votes
Loading... 2,156 views

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

  1. MrMonkeyboy1501 says:

    Thanks for this very useful and clearly´╗┐ explained keep up the good work ­čÖé

  2. MEvans2703 says:

    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.

  3. Aniik0 says:

    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.

  4. Jon Flynn says:


  5. bachelor3000 says:

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

  6. East17au says:

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

  7. cbgmtl says:

    Very instructive,´╗┐ thanks

  8. BSKseeker says:

    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.

  9. paterick4o8 says:

    worked for´╗┐ me, thanks!

  10. mpattuj says:

    was very hekpful,´╗┐ thanks a ton

  11. ShonniePooh73 says:

    Thank you a billion times´╗┐ over! This was very useful

  12. marlennegrl says:

    Great tutorial! Thank you!´╗┐

Leave a Reply

Your email address will not be published. Required fields are marked *