TOROW Function in Excel: Flatten Into One Row
TOROW flattens a block into a single row, optionally skipping blanks and errors.
Read article →Lookup & Reference
Excel Lookup & Reference functions explained with syntax, examples and common mistakes.
📊
← Excel
Lookup & Reference
Excel Lookup & Reference functions explained with syntax, examples and common mistakes.
📄 42 articles⬇️ 39 with practice files🕒 Updated 13 Oct 2026
🎓 Start here: Excel for India Course → 🎓 Start here: Excel Course: Beginner → Expert → 🎓 Start here: Bank Statement Automation →WRAPCOLS Function in Excel: Fold a List Into Columns
WRAPCOLS Function in Excel: Fold a List Into Columns
WRAPCOLS takes a long list and wraps it into columns of a fixed height — printable labels, seating plans.
Read article →WRAPROWS Function in Excel: Reshape a List Into a Grid
WRAPROWS Function in Excel: Reshape a List Into a Grid
WRAPROWS reshapes a single column into rows of a fixed width — e.g. a pasted list where every 3 lines are one record.
Read article →CHOOSECOLS Function in Excel: Pick Specific Columns
CHOOSECOLS Function in Excel: Pick Specific Columns
Dynamic ArrayLevel: ExpertAvailable in: Excel 365 / 2021+CHOOSECOLS returns only the columns you list, in the order you list them.Syntax=CHOOSECOLS(array.
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 →COLUMNS Function in Excel: How Many Columns in a Range
COLUMNS Function in Excel: How Many Columns in a Range
COLUMNS counts columns in a range — useful for dynamic column numbers and checks.
Read article →IMPORTTEXT Function in Excel: Import a Text or CSV File Into the Grid
IMPORTTEXT Function in Excel: Import a Text or CSV File Into the Grid
IMPORTTEXT (2026) loads a .txt, .csv or .tsv file into a refreshable dynamic array with one formula, with options for delimiter, encoding and rows…
Read article →DROP Function in Excel: Remove First or Last Rows
DROP Function in Excel: Remove First or Last Rows
DROP removes rows or columns from the start (positive) or end (negative) of an array — e.g. strip headers or total rows.
Read article →COLUMN Function in Excel: Column Number of a Cell
COLUMN Function in Excel: Column Number of a Cell
COLUMN returns the column number (A = 1). Handy for VLOOKUP formulas that fill across.
Read article →CHOOSEROWS Function in Excel: Pick Specific Rows
CHOOSEROWS Function in Excel: Pick Specific Rows
CHOOSEROWS returns the rows you specify — first, last, or any list of positions.
Read article →EXPAND Function in Excel: Grow an Array to a Fixed Size
EXPAND Function in Excel: Grow an Array to a Fixed Size
EXPAND pads an array to a given number of rows and columns — handy before VSTACK when pieces have different widths.
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 →