Excel 2010 Tutorial - Vlookup Function

In this video from the Excel 2010 Tutorial series, School of Technology Program Coordinator, Justin Denton, teaches how to find and use the Vlookup Function in Microsoft Excel 2010. This tutorial video is a great beginning step to your courses in technology at Rasmussen College.

Transcript

We have this one called Value Lookup, or it's called VLOOKUP. What that's going to do is, you'll give it a range-- I first want to find out what value I want to look up, which is 45. I want to find the number 45. And then I need to find out where I'm going to actually look for that value. I'm going to look for the range A4 to A13, because that's where all my information is. After that, I need to find out what column and index number, which typically will be default one, because it's the first column, that's what I'm looking up. And then what I want to do if it's false. If I do false, it'll display 45 if it finds it. If I don't have 45 and I say put 40, well false is not going to return a value at all. It'll say not applicable.

If I go back and maybe I want to put 45 down here, it will still return 45 because it's in the range. But maybe you really don't care what the value is, you just want something that's close to 45. Well you can type in true and it's going to be an approximate match. So if I change this to 43, it's going to go with something approximate. It's not really the best way to do it, but you have the ability to throw true in there and it'll find whatever value in here is somewhat close. It's not always going to be accurate, but there's an option to do it.

If you know you're not going to have that value and you want something close, you can pull that out. I typically like to go with false because I want the exact match. So if I put 45 back in here, I'm going to have 45 again. You can get pretty lengthy with how you do it. So if you've got a lot of customer data in here, and you just want to build a formula off in maybe the H column and have the formula just go through each line and determine if maybe an account statement is overdrawn, then it would key off if that's a negative value. Or maybe if it's below zero, put negative 0.1 or something like that, then you could flag it and have it pull off into another column.

Also something that we can do with conditional formatting, which will give it a little more oomph when you actually look at it because you can color those cells--

External links provided on Rasmussen.edu are for reference only. Rasmussen College does not guarantee, approve, control, or specifically endorse the information or products available on websites linked to, and is not endorsed by website owners, authors and/or organizations referenced.

Kendall Bird is an Online Community Specialist for Rasmussen College. With her Bachelor’s degree in public relations and a passion for social media, she enjoys writing motivating and enthusiastic blog content to encourage future, current and former students to learn more about their discipline of study. Kendall’s ultimate goal is to generate a positive community through blogging to promote learning and change lives.

comments powered by Disqus
Share Your Story Ideas
Our campuses and online community have stories to tell and we want to hear them! Did your campus raise the most money in the community for an organization? Do you have online study tips for other students? Would you like to share a personal success story about overcoming an obstacle while earning your degree?
To have your story idea considered:
  • You must be a faculty member, current student or graduate
  • Story ideas must be regarding Rasmussen College or an inspiring story about a student at Rasmussen College
  • Your submission must be original and may not have been published elsewhere online already
Please Note: Your story idea may be featured on the Rasmussen College News Beat or on one of our social networks. A member of our news team will contact you should we move forward with a blog post.
Feel free to suggest an idea for a blog post to be featured on the Rasmussen College News Beat by filling out the form below:

First Name: (required)

Last Name: (required)

Email Address: (required)

Phone Number: (required)

500 characters or less

close

Your Story Idea Has Been Submitted

Thank you for sending us a story idea! We’re reviewing submissions and may contact you soon to learn more about your story. In the meantime, make sure to check out our current blogs to see what’s happening on campus.

close