Relational tables
Search related tables
Extract unique distinct values from a relational table
Working with three relational tables
Highlight lookups in relational tables
Merge two relational data sets
Vlookup and return multiple values
Improve your VLOOKUP formula and return multiple values
VLOOKUP in a filtered Excel Table and return multiple values
Search and return multiple values
Partial match for multiple strings – AND logic
Partial match and return value with highest level
Distribute values across numerical ranges
Formula categories
Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup