From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Getting exact table data with the VLOOKUP function

Getting exact table data with the VLOOKUP function

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Getting exact table data with the VLOOKUP function

- Excel's powerful VLOOKUP function is often used for matching up data, or looking up data exactly. It also has a use, and you might have seen it in a previous movie, for an approximate match. Any time you're trying to match up data that's text, or it's an ID type number that must be exact, we use VLOOKUP in its exact match format slightly different than the other format for approximate lookups. In this worksheet called VLOOKUP Exact, it's in the workbook 10 - IF VLOOKUP COUNTIF, in column H, we need to know the department for each product we have in our list by the way, these products might look like they're repeating but they could be of different size, and or different color and off to the right we've got a list of all of our products a master list, which department each one is based in, and also the category. Now to make this a little bit more visible on the screen I'm going to be hiding columns D, E, F, and G for the moment we don't need to see those. I'm going to drag across the…

Contents