Completed
10. Lookup whole column of days sales with XLOOKUP to then add with SUM function
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Lookup Functions: XLOOKUP, FILTER, XMATCH, LOOKUP, and SWITCH - Part 6
Automatically move to the next video in the Classroom when playback concludes
- 1 1. Introduction
- 2 2. Topics in video
- 3 3. Problems with AI and Excel
- 4 4. XLOOKUP arguments
- 5 5. Exact Match Lookup to lookup a product price
- 6 6. Data Validation to add a dropdown list to a cell to facilitate accurate XLOOKUP results
- 7 7. Different types of Data Validation
- 8 8. How XLOOKUP can be better than XLOOKUP
- 9 9. Lookup an employee record whole row with XLOOKUP
- 10 10. Lookup whole column of days sales with XLOOKUP to then add with SUM function
- 11 11. Exact Match or Next Smaller lookup
- 12 12. Characteristics of tax, commission, sales discount, and other similar lookup tables that lead us to use the LOOKUP function rather than the XLOOKUP function
- 13 13. Comprehensive look at how XLOOKUP and LOOKUP perform and handle Exact Match or Next Smaller lookup, also known as Approximate Match Lookup.
- 14 14. Characteristics of tax table leads to using LOOKUP function, even though XLOOKUP can do some crazy tricks
- 15 15. LOOKUP function arguments
- 16 16. How LOOKUP Binary Search works
- 17 17. Use LOOKUP function on same example as XLOOKUP
- 18 18. Binary option in XLOOKUP is not as fast as LOOKUP
- 19 19. XLOOKUP settings to simulate exact return results as XLOOKUP, but is very slow
- 20 20. Timing results of LOOKUP and XLOOKUP
- 21 21. XLOOKUP and LOOKUP function algorithms to see how the binary options in each can yield different answers
- 22 22. XLOOKUP can perform Vertical or Horizontal Lookup
- 23 23. XLOOKUP with Exact Match or Next Bigger to lookup pipe size for land drainage pipes
- 24 24. Custom Number Formatting to show numbers in inches
- 25 25. Wildcard lookup with XLOOKUP to do a partial text lookup
- 26 26. First-To-Last and Last-To-First search_mode options
- 27 27. First-To-Last and Last-To-First search yield same results when there are no duplicates in the lookup_array
- 28 28. What happens when there are duplicates in the lookup_array?
- 29 29. Lookup First-To-Last when there are duplicate values in lookup_array. See example of looking up employees first day of work.
- 30 30. Lookup Last-To-First when there are duplicate values in lookup_array. See example of looking up employees last sales amount.
- 31 31. XLOOKUP to use two lookup values to lookup a City and Product Price
- 32 32. Two-Way lookup with the XLOOKUP function. Example of getting a tax rate for employee with weekly wage and number of allowances
- 33 33. FILTER function to return multiple items from one lookup value.
- 34 34. XMATCH function to compare two lists
- 35 35. SWITCH function to lookup three different lookup tables inside the LOOKUP function
- 36 36. Homework – Practice Problems for you!
- 37 37. Summary
- 38 38. Closing
