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.
12 responses to “Microsoft Excel VLOOKUP Tutorial for Beginners – Office Excel 2003, 2007, 2010”
Leave a Reply Cancel reply
Video Tutorials
Bringing you the best video tutorials for Photoshop, Illustrator, Fireworks, WordPress, CSS and others.
Video tutorial posted 21/07/12
Category: Uncategorized
Pages
Random Videos
-
3ds max glow tutorial
4,259 views
-
Unity Coding Tips Part 1: Events and Delegates
4,524 views
-
After Effects Tutorials – Color Correction
4,144 views
Video Categories
- 3DS Max Tutorials (150)
- After Effects Tutorials (160)
- C# Tutorials (121)
- Colour (6)
- Crazy Effects (1)
- CSS Tutorials (120)
- Dreamweaver Tutorials (139)
- Excel Tutorials (127)
- Featured (10)
- Fireworks Tutorials (131)
- General Effects (9)
- HTML Tutorials (143)
- Illustration and Vector (1)
- Illustrator Tutorials (174)
- IMove Tutorials (119)
- Lightroom Tutorials (145)
- People and Faces (3)
- Photoshop Tutorials (169)
- Text Effects (7)
- Uncategorized (32)
- WordPress Tutorials (140)
Tags
VideoTutorials.co.uk
-
Videotutorials.co.uk offers the web's best Photoshop tutorials, Illustrator video guides, CSS and HTML tutorials and much more all in one place. With new videos being added every day, you can learn how to master software and code to give your images and website some great effects.
Our site has beginner, intermediate and advanced video tutorials of varying lengths so you can learn a new skill at your own speed and level. So whether you're a web designer, print designer or just wanting to edit some family photos, you can get to it quickly and easily using these free video guides. (more)
Thanks for this very useful and clearly explained keep up the good work 🙂
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.
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.
Yes!
Awesome vid….one question: by using the term “anchor”, are you referring to setting absolute values ($) in the formulas?
thanks for the video, tho am looking for one that deals with 2 different spread sheets.
Very instructive, thanks
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.
worked for me, thanks!
was very hekpful, thanks a ton
Thank you a billion times over! This was very useful
Great tutorial! Thank you!