Modern Excel Formulas

Lookup example

Modern Excel Formulas Lessons Lookup example

Summary

This video looks at one final example using XLOOKUP to show how to apply the techniques from the course.

EXAMPLE FILE: Modern Excel Formulas – Start.xlsx > Lookup example

Lessons

  1. Welcome & introduction
  2. Download the example files
  3. From ranges to arrays
  4. Arrays & array functions
  5. Lifting
  6. Example (Part #1)
  7. Broadcasting
  8. Example (Part #2)
  9. Pairwise lifting
  10. Example (Part #3)
  11. Boolean logic
  12. Example (Part #4)
  13. Variables (LET Function)
  14. Example (Part #5)
  15. Lookup example
  16. Wrap up
  17. Feedback