Lookup


show more Lookup provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

Lookup

Let's say you wanted to look up the current cost of an item based on the Item# in our inventory list. You can look up the data quickly and efficiently, find a specific data in a list, and automatically verify that you're using the correct data by using the Lookup feature. After you've looked up the data, you can perform calculations or display the results with the values that are returned. Now there's several ways to look up values in a list of data and display the results. Since this is an essential basics video, we're going to learn about the easiest type of lookups.

And this is the VLookup. What we're going to be doing here is we're going to be looking up information in columns. Open up Inventory list 19. And this is the end result that we're heading for, so that we can see what we want to come up with. We now have a new sub table on the worksheet, that identifies the item number and its current cost. Right now, the item number is 14 and the current cost ...

Lookup
Video duration: 7m 25s 5h 13m Beginner

Viewers:

Lookup provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...