From the course: Excel: Lookup Functions in Depth

Unlock this course with a free trial

Join today to access over 24,200 courses taught by industry experts.

Finding exact and approximate matches with VLOOKUP and HLOOKUP

Finding exact and approximate matches with VLOOKUP and HLOOKUP - Microsoft Excel Tutorial

From the course: Excel: Lookup Functions in Depth

Start my 1-month free trial Buy for my team

Finding exact and approximate matches with VLOOKUP and HLOOKUP

“

- [Instructor] On this worksheet called ExactMatch, we've got some ratings in column E, but we want to convert them into a numerical score based on that list over in columns A and B. You'll see the same list off to the right. Now, we could be using VLOOKUP or HLOOKUP, and I think almost immediately people would say, "Well, the list to the left is a lot easier to read and work with." VLOOKUP, think of V for vertical, means we're going to be comparing this entry here with the leftmost column. By definition, VLOOKUP means compare a value with the leftmost column of a list somewhere. Equal, as you type it, you can press VL + Tab. We're looking up the word fair, comma, over in these cells here. If there's nothing else in these columns, we can simply drag across columns A and B. That's easier to read. Comma. Now, it's a little bit strange at first, if you've never worked with VLOOKUP, we indicate the column index number. What does that mean? Based on what we've highlighted, and we've…

Contents