Category: Lookup and References

Lookup and references functions, comes with Excel

Walking Columns

Get 3rd Wednesday of month

Repeated Offset

Sorting with functions only

Searching table in 2 dimensions.

Search across sheets in function

Min Max vehicle

GoLast to jump to last cell in a column

CHOOSE – tree of decisions

Looplist – Repeating months using formulas

Skills Grid