XLOOKUP Express Tour

Описание: An express tour of the XLOOKUP function in Excel. Discover how XLOOKUP consolidates all the best parts of, and overcomes the weaknesses of, VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX and IFERROR.

😃 TIME CODES
00:00 Intro
00:34 About our example data
01:24 How to do an XLOOKUP if your lookup value is not in the first column
03:44 How to handle XLOOKUP errors where no match is found
05:34 How to create a genuine database lookup with multiple return values (XLOOKUP + SPILL)
06:57 How to use XLOOKUP with Approximate match (going DOWN to find the closest match)
09:26 How to use XLOOKUP with Approximate match (going UP to find the closest match)
10:42 How to use XLOOKUP for a 2-way lookup (the intersection of matching row and column)

Did you get any ideas or inspiration from this video? Share in the comments below and don't forget to click the THUMBS UP button.

😃 SHARE:
   • XLOOKUP Express Tour  

😃 ABOUT THE PRESENTER:
Jason Morrell helps people of all levels to leverage the power of Microsoft Office. Delivering training since 2002, he loves to simplify the hard stuff and provide helpful, actionable advice that has been proven to slash hours from daily computer tasks. Jason lives with his wife and 4 kids on the beautiful Gold Coast in Queensland, Australia.

😃 LET'S CONNECT!
https://officemastery.com (free training resources)
  / officemastery  
  / jkmorrell  
   / jasonmorrell  

Have a fantastic day!