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,374 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.