Look up any Excel function — syntax, a real example, and when to use it.
Returns a value from a list based on a position number you provide.
Returns only the rows of a range that meet a condition, automatically spilling the matching rows into neighboring cells.
Returns the value at a given row and column position within a range.
Returns the position of a value within a range, rather than the value itself.
Returns a range sorted by a column you specify, automatically spilling the sorted results into neighboring cells.
Sorts a range based on the values in a different range, rather than a column within the range itself.
Returns each distinct value from a range exactly once, automatically spilling the results into neighboring cells.
Looks for a value in the first column of a range and returns a value from a column you specify in the same row.
Searches a range for a value and returns a corresponding value from another range — the modern replacement for VLOOKUP.