In this video from the Excel 2010 Tutorial series, School of
Technology Program Coordinator, Justin Denton, teaches us about
VLookup in Microsoft Excel 2010. This tutorial video is a great
beginning step to your courses in technology at Rasmussen
College. The next formula, per se, is what's called a value look
up. If you want to look up a given value based on a code-- we
know that we've got product codes. We know that we have an item
name. But I want to know what those details are about each given
item. We have our product codes in a different tab which lists
the product name, the product code, and the actual product
details. So we know it's a spoon, but what kind of spoon it is.
It's a six inch dinner spoon with a gold tone. Well, I want to
return those on the fly back to my inventory list. And if this
spoon changes, maybe the code changes, I want it to
automatically update. To do that, there's a VLOOKUP function. So
equals VLOOKUP, which basically stands for value look up. You'll
do your open bracket. And t