From the course: Mastering Lookup Functions in Excel: Seven Powerful Formulas
Join today to access over 25,600 courses taught by industry experts.
Solution: Master the INDEX function - Microsoft Excel Tutorial
From the course: Mastering Lookup Functions in Excel: Seven Powerful Formulas
Solution: Master the INDEX function
(bright upbeat music) - [Instructor] How did you do? Let's go over the solution together. We're trying to get the customer name for order 110940. In our first challenge, we want to get our answer by just specifying the row number. In this case, I'll count down to the row number, getting me to 7. I'll enter 7 over here, and then I'll populate my index function. I'll select my customer name from my index. I'll then hit comma and point to the row number as such. Then I'll close my parentheses. And as you can see, our value populated. Let's do this another way. This time, giving our column as the input. So to get to the column, I'll count 1, 2, 3, 4, 5. Let's now write our index function. I'll select all the information for this order over here. Then for the row number, because we don't have a row, I'll enter zero. For the column, I'll go ahead and point as such to column number 5. I'll then hit enter, and our value populates again. Okay, now let's finalize this and enter in both the row…
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.