TOCOL Function in Excel: Syntax, Examples and Free Practice
TOCOL is an Excel Lookup & Reference function. Returns an array as a single column.
TOCOL syntax
Arguments
array: The range or array to evaluateignore: What kind of blank or error values to ignore (optional)scan_by_column: Whether to scan the array by column instead of by row (optional)
When to use TOCOL
TOCOL is used to pull matching data from one part of a workbook into another.
Practice TOCOL online, free
Open the live Excel-style spreadsheet and try TOCOL yourself. No Excel install or sign-up needed to start.
Practice TOCOL now →More Lookup & Reference functions
Frequently asked questions
What does the TOCOL function do in Excel?
Returns an array as a single column.
What is the syntax of TOCOL in Excel?
The syntax is =TOCOL(array, [ignore], [scan_by_column]). array: The range or array to evaluate; ignore: What kind of blank or error values to ignore (optional); scan_by_column: Whether to scan the array by column instead of by row (optional).
Where can I practice TOCOL online for free?
Open the free live spreadsheet on Cellgrids and try TOCOL yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Lookup and Reference functions · Excel case studies · Excel tutorials · Excel shortcuts