From the course: Excel: Lookup Functions in Depth
Join today to access over 23,200 courses taught by industry experts.
Use the MATCH and INDEX functions together
From the course: Excel: Lookup Functions in Depth
Use the MATCH and INDEX functions together
- Although Excel's INDEX function and MATCH function can each be used independently, and you might have seen that in previous movies, sometimes you need to use the two together. If you do not have the latest version of Microsoft 365, you won't have access to the XLOOKUP function. And what we need to do sometimes is do what would be called the equivalent of a leftward VLOOKUP. Using the VLOOKUP function, you cannot look leftward in a list. But that's what we need to do, based on the data we're seeing on this worksheet, called index match. There's a list over in columns A, B and C. We can't change the order of it. It's used by functions and formulas in other workbooks and in other worksheets. So its order is static. But we've got a list over in column G, and we need to pull in the names based on the Social Security number. So the idea would be, if you were using VLOOKUP, to say let's look this up in a list and then…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.