From the course: Mastering Lookup Functions in Excel: Seven Powerful Formulas
Join today to access over 25,600 courses taught by industry experts.
Challenge: Find a value with INDEX and MATCH - Microsoft Excel Tutorial
From the course: Mastering Lookup Functions in Excel: Seven Powerful Formulas
Challenge: Find a value with INDEX and MATCH
(upbeat music) - [Instructor] We're going to cover three challenges with index match in this exercise. Our first challenge will be to find the product name in a list of orders. We'll specify the order number over here, and then dynamically get the product name over here. Our next challenge will be similar, only this time we'll be looking up a value horizontally with index match. Here we'll want to find the value of interest expense for a specified month. Lastly, we'll want to build on this second assignment by inputting both the metric as well as the date to get our value over here. Think you can solve these? See you in the next video where we'll go through the answers together.
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.