From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

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

INDEX/MATCH

INDEX/MATCH

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

INDEX/MATCH

“

It's time to talk about index match. Index match can be used as a more robust alternative to VLOOKUP. But now we have XLOOKUP. And in my opinion, XLOOKUP is more robust than index match and VLOOKUP. But let me also say, I am not here to bash any one of these three. IndexMatch, VLOOKUP, or XLOOKUP. You use what works for you in the situation that you are in. All right, so let's get into IndexMatch. In G2, I have an ID, and I wanna retrieve the name and the specialty. See, we're gonna do it twice. All right, notice how the data is set up. The ID is all the way to the right, and we need to look left. VLOOKUP cannot look left. If we wanted to use VLOOKUP, we could move the ID column over to be in the first column. And sometimes we don't have that option. There'd be too much stuff to move around to get out of our way. It could be a hassle sometimes. So index match equals, and I'm gonna start with match first because it's nested inside the index. So I'm going to work from the inside…

Contents