00. Intro (4:37)
01. Video Time Conversion (27:39)
Separating Text Strings
FIND, LEFT, LEN, MID, RIGHT
Converting to Seconds
Adding Times
QUOTIENT, MOD, TEXT Functions
How Many Hours in X Seconds
Force 2 Digit Minute, Sec 00:00
02. XLOOKUP Part 1 (13:28)
Benefits of XLOOKUP
Look up to the left or right
Return multiple results
Vertical or horizontal lookups
Reverse search (last to first)
Defaults to an exact match
Supports wildcards (*, ?, ~)
Sspecify a value if not found
Return entire columns or rows
Can work with arrays
Review of VLOOKUP
Weekday Lookup
Absolute References F4
Still works if you move ranges
Student Grades
Grade Lookup Table
List doesn't have to be in asc order
Exact Match Lookup
Approximate Lookup (Range)
Match Mode: Exact Match or Next Smaller Item
03. XLOOKUP Part 2 (11:13)
Returning multiple values
match_mode
Match Not Found: if_not_found argument
Wilcard Searches * ? ~
search_mode
Binary Searches - discussion
XMATCH
04. XLOOKUP Part 3 (16:48)
Two-way lookups (double lookup)
Clothes, Sizes, Look up Price
Course, Grade, Look up Letter
BONUS: Developer Tab
Combo Box
Input Range
Cell Link
05. Review (2:49)
