From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Challenge 2: Two-way lookup

Challenge 2: Two-way lookup

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

Challenge 2: Two-way lookup

“

(modern techy music) - [Instructor] Right, this next challenge asks you to do a two-way lookup. We have a list of these pairs of people who have been assigned these shifts. Day four morning, we've got Erika and Cheryl. So if we wind up with day four in C2, and morning in C3, we'd want to have Erika and Cheryl pop up. But right now it says day three and evening, create the two-way lookup that will automatically retrieve the right pair. (modern jazzy beat) Here we go. I'm going to put the result right here, and equals XLOOKUP. Double click. Look up value. Day three, comma, look up array. Look for day three here. Comma, return array. Oh, we got to do another XLOOKUP. Double click. Look up what, evening, comma, look it up, where? In here. Comma, return array is right there. Okay, and close the XLOOKUP. Close the first XLOOKUP and enter Ariel and Bill, can we verify that? Right, so let's change this.…

Contents