INDEX Function in Excel: Return the Value at a Row and Column Position
INDEX returns the value at a given row (and optional column) of a range. Combined with MATCH it is the most flexible lookup in…
Read article →Lookup & Reference
Excel Lookup & Reference functions explained with syntax, examples and common mistakes.
SORTBY Function in Excel: Sort by Another Column
SORTBY Function in Excel: Sort by Another Column
SORTBY sorts one range by the values in another — even by a column you do not display.
Read article →IMAGE Function in Excel: Put a Picture Inside a Cell
IMAGE Function in Excel: Put a Picture Inside a Cell
IMAGE shows an image from a web address inside a cell — product catalogues that sort and filter with their pictures.
Read article →UNIQUE Function in Excel: Distinct List Without Remove Duplicates
UNIQUE Function in Excel: Distinct List Without Remove Duplicates
UNIQUE returns the distinct values of a range, updating automatically as data changes.
Read article →HLOOKUP Function in Excel: Look Up Across the Top Row of a Table
HLOOKUP Function in Excel: Look Up Across the Top Row of a Table
HLOOKUP is VLOOKUP turned sideways: it searches the top row and returns a value from a row below.
Read article →FILTER Function in Excel: Return Every Row That Matches
FILTER Function in Excel: Return Every Row That Matches
FILTER returns all rows (or columns) that meet a condition, and the result updates live as data changes.
Read article →ADDRESS Function in Excel: Build a Cell Address as Text
ADDRESS Function in Excel: Build a Cell Address as Text
ADDRESS returns a cell reference as text from row and column numbers — often combined with MATCH to report “where” something is.
Read article →HSTACK Function in Excel: Put Arrays Side by Side
HSTACK Function in Excel: Put Arrays Side by Side
HSTACK joins arrays horizontally — build a small report from separate results in one formula.
Read article →XLOOKUP Function in Excel: The Modern Lookup That Replaces VLOOKUP
XLOOKUP Function in Excel: The Modern Lookup That Replaces VLOOKUP
XLOOKUP finds a value in one range and returns the matching item from another. It looks in any direction, defaults to exact match, and…
Read article →IMPORTCSV Function in Excel: Import a CSV File Into the Grid
IMPORTCSV Function in Excel: Import a CSV File Into the Grid
IMPORTCSV (2026) is the simple version of IMPORTTEXT for standard CSV files: one argument, a refreshable dynamic array.
Read article →VLOOKUP Function in Excel: Look Up a Value in the First Column of a Table
VLOOKUP Function in Excel: Look Up a Value in the First Column of a Table
VLOOKUP finds a value in the first column of a table and returns a value from another column in the same row.
Read article →CHOOSE Function in Excel: Pick From a List by Number
CHOOSE Function in Excel: Pick From a List by Number
LookupLevel: IntermediateAvailable in: Excel 2007+CHOOSE returns the n-th item from a list of values you type in the formula.Syntax=CHOOSE(index_num.
Read article →