From the course: Mastering Lookup Functions in Excel: Seven Powerful Formulas
Join today to access over 25,200 courses taught by industry experts.
Challenge: Master the INDEX function - Microsoft Excel Tutorial
From the course: Mastering Lookup Functions in Excel: Seven Powerful Formulas
Challenge: Master the INDEX function
(upbeat music) - [Instructor] Let's master our understanding of the INDEX function. We're going to go over three challenges here. Here's a table showcasing our sales, and in all three challenges, I want to get the customer name for order number 1100940. For the first two challenges, we'll give just one input and get the corresponding value. In the last challenge, we'll give both inputs. Let's start with our first challenge. Upon entering the row number over here, I should be able to get the customer name for this order. In our second challenge, upon giving the column number over here, I should again be able to get the customer name from this order. In our third challenge, we'll give both the row and the column to get our customer name value from this order as such. See you in the next video with a solution.
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.