From the course: Excel: Advanced Formulas and Functions
Join today to access over 25,300 courses taught by industry experts.
Challenge 1: Assignments - Microsoft Excel Tutorial
From the course: Excel: Advanced Formulas and Functions
Challenge 1: Assignments
(upbeat bouncy music) - [Instructor] In this midterm challenge, the goal is to create a two-way lookup. Let's look at the data. Got assignments, and we've got days, and it's easy to see, on Wednesday, Belinda is the person who's doing the driving and errands. Now, let's look at cells D2 and D3. We want to be able to change those values and then have it retrieve who is assigned. And you get to pick the cell where the result goes. All right? So when we pick something like Wednesday and A/V, we want Myers' name to show up somewhere, all right? Now, go ahead and create that two-way lookup. (upbeat music) (tranquil music) Welcome back, and let's do this two-way lookup. Give myself some room. I'm going to slide this out of the way. Put the result here. I want, equals, XLOOKUP. Double click it. Look up, what? Look up Monday. Comma. Look it up where? In this range. Comma, return array. I actually want another…
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.