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--

This piece of ad content was created by Rasmussen College to support its educational programs. Rasmussen College may not prepare students for all positions featured within this content. Please visit www.rasmussen.edu/degrees for a list of programs offered. 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. Rasmussen College is a regionally accredited private college and Public Benefit Corporation.

Kendall is an Online Community Specialist at Collegis Education who oversees online communities on behalf of Rasmussen College. She has a passion for social media and enjoys motivating and encouraging former, current and future learners.

Receive Personalized Information Today

  • Personalized financial aid
  • Customized support services
  • Detailed program plan
  • Attend a no-obiligation Nursing Information Session
  • Meet the Dean of Nursing
  • Enrollment application
  • Personalized financial aid
  • Career path guidance

How may we contact you?

Please complete all fields

What would you like to study?

The program you have selected is not available in your area. Please select another program of interest.

By requesting information, I authorize Rasmussen College to contact me by email, phone or text message at the number provided.

close