Excel Expert 11 Lessons

This class focuses on the new XLOOKUP function which was added to Excel 365 in 2019. We will learn all of the ways to use XLOOKUP in addition to double-lookups (two-way lookups). We will also take some time to go over some string manipulation functions, turn on the Developer toolbar, and learn how to create Combo Boxes. Click here for the Full Outline.

Please note: XLOOKUP is only available to Microsoft 365 subscribers, NOT retail Office 2019 users.

S M L XL FS

Lessons

00. Introduction (4:38)
Lesson 01. Video Time Conversion (27:37)
Lesson 02. XLOOKUP Part 1 (13:28)
Lesson 03. XLOOKUP Part 2 (11:13)
Lesson 04: XLOOKUP Part 3 (16:48)
Lesson 05: Review (2:49)

Resources

Full Course Outline
Handbook PDF - Coming Soon
Skills Test Quiz - Coming Soon
Certificate of Completion
Post-Class Survey

Questions

Post your questions or comments below

Issue with XLOOKUP Upload Images Link
Tim Schmidt
6 months ago

I am using the same example as in your video. I keep betting the #NAME for my solution. This is the formula I am using:
=xlookup(J5,A2:A4,xlookup(J6,B1:F1,B2:F4))
Where J5 = Jacket, A2:A4 contains Jacket, J6 = S, B1:F1 contains S, and the price is in the B2:F4 section. Read More...

Richard Rost
6 months ago

Yeah, that's the problem. XLOOKUP is only available to Microsoft 365 subscribers. Initially it was announced that it would be included in Office 2019, but Microsoft changed it to 365 only. That's why you're getting the error. Your Excel has no idea what XLOOKUP is.

Tim Schmidt
6 months ago

I want to say that you havr helped me in a lot of questions, bur could you tell me how I get Office 365. I purchased yearly for $75.00 but can not see how to get it. Any assistance would be greatly appreciated.
Tim

Show 1 More Reply...