From the course: Excel Formulas and Functions Quick Tips
Join today to access over 24,800 courses taught by industry experts.
Use INDEX and MATCH to retrieve a value - Microsoft Excel Tutorial
From the course: Excel Formulas and Functions Quick Tips
Use INDEX and MATCH to retrieve a value
- [Instructor] If you can't use XLOOKUP, you can use the functions INDEX and MATCH in combination to perform similar functionality. Let's use INDEX and MATCH together to find out if the state of Arkansas is active or inactive in this column. The MATCH function will return the position of the required value, in this case where the state of Arkansas is from this range in column E. The lookup value is Arkansas, which is currently in cell I1. The lookup array is from column E, and our match type will be an exact match, so I'll put a zero in. In this case, Arkansas is in place four from this range from column E. The INDEX function will return a specific value at a specific position, so now we can find out what's in place four in the status column. Let's put these together and use INDEX to return the value at this location that MATCH returned. Our array this time is from column F. The row number that I want to return is the location that MATCH is going to return, so we can use the same…
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.