AREAS Function in Excel: How Many Blocks in a Reference
AREAS counts separate ranges in a reference — used with INDEX’s area_num argument to switch between tables.
Read article →HYPERLINK Function in Excel: Clickable Links From a Formula
HYPERLINK Function in Excel: Clickable Links From a Formula
HYPERLINK builds a clickable link — to websites, files, or other sheets in the same workbook.
Read article →GETPIVOTDATA Function in Excel: Reliable Numbers From a Pivot Table
GETPIVOTDATA Function in Excel: Reliable Numbers From a Pivot Table
GETPIVOTDATA pulls a value from a pivot by field names, not by cell position — so your report keeps working when the pivot grows…
Read article →ISNA Function in Excel: Is It “Not Found”?
ISNA Function in Excel: Is It “Not Found”?
ISNA returns TRUE only for #N/A — the “not found” result — so you can react to missing lookups specifically.
Read article →MATCH Function in Excel: Find the Position of a Value
MATCH Function in Excel: Find the Position of a Value
MATCH returns the position of a value in a list — the “where is it?” half of INDEX/MATCH.
Read article →XMATCH Function in Excel: MATCH With Better Defaults
XMATCH Function in Excel: MATCH With Better Defaults
XMATCH returns the position of an item, defaulting to exact match, and can search from the end or use wildcards.
Read article →DGET Function in Excel: Get the One Matching Value
DGET Function in Excel: Get the One Matching Value
DGET returns a single value from the row that matches — and, usefully, refuses to guess when more than one row matches.
Read article →INDIRECT Function in Excel: Build a Reference From Text
INDIRECT Function in Excel: Build a Reference From Text
INDIRECT turns text such as "Mar!B5" into a real reference — the key to dependent dropdowns and summary sheets that switch between monthly tabs.
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 →The Excel Camera Tool: A Live Picture of Any Range
The Excel Camera Tool: A Live Picture of Any Range
Excel’s hidden Camera tool puts a live, resizable picture of a range anywhere — perfect for one-page dashboards that mix tables of different column…
Read article →INDEX Function in Excel: Return the Value at a Row and Column Position
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 →XLOOKUP with Two (or More) Criteria — Plus the INDEX-MATCH Version
XLOOKUP with Two (or More) Criteria — Plus the INDEX-MATCH Version
Look up a value using two conditions — product AND region, or employee AND month — with XLOOKUP, INDEX-MATCH, or a helper column. With…
Read article →