From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Finding exact matches with VLOOKUP

Finding exact matches with VLOOKUP

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

Finding exact matches with VLOOKUP

“

- If you're trying to use the VLOOKUP or HLOOKUP function for an exact match, that could by the more common use. In this worksheet called ExactMatch, we've got a formula in cell F2. Now before I show you the formula, look at the data to the left. We've been using a rating scheme for years, let's say. We've got people's names here, we've got the ratings here, we've been using these words over and over and over again. We've got a huge list in front of us. We've decided to convert these into a numerical score. A table over in columns A and B indicates what we want to convert these into, we've got numbers over here. We're about to use VLOOKUP as an exact match. When we were using it for an approximate match, the table that we were using had to have the left column in ascending order. It makes no difference here. We want these to be in a sensible order. They're actually in order by the column we see to the right. So, in cell F2 is a function already set up, and you could say so far, so…

Contents