Excel 365 Intro to XLOOKUP function - beginners guide!

Beginner intro into XLOOKUP function.

Timecodes:
0:00 - Intro
0:17 - Example for usage of XLOOKUP
0:33 - Setup data as a TABLE (optional)
0:45 - Writing XLOOKUP formula
2:03 - Multiple XLOOKUP functions in a single formula
3:30 - Use range as lookup value to create SPILL output
3:38 - Table references used in formula
4:33 - All together now!