Formulas > =SCAN()

How To Use SCAN() Function in Google Sheets


Scans an array and produces intermediate values by application of a LAMBDA function to each value. Returns an array of the intermediate values obtained at each step.

Common questions about the SCAN formula include:

What does SCAN do?
How does SCAN work?
What is the syntax for the SCAN formula?

The SCAN formula can be used to search for specified text within a range of cells. It can be used to quickly and easily identify specific data or text strings.

The SCAN formula can be commonly mistyped by forgetting to include the quotation marks around the text string you are searching for.

Common ways the SCAN formula is used inappropriately include: forgetting to include the quotation marks around the text string, incorrectly specifying the range of cells to search, or not properly specifying the search criteria.

Common pitfalls when using the SCAN formula include: making sure the formula is correctly structured and includes all the required parameters, making sure the text strings being searched for are surrounded by quotation marks, ensuring that any wildcard characters are included within square brackets, and making sure the range to search is specified correctly.

Common mistakes when using the SCAN Formula include: using the wrong function (for example, using SEARCH instead of SCAN); providing incorrect search criteria (such as not providing quotations around a text string when using wildcards); forgetting to specify wildcard characters (when applicable); or mistyping the function syntax.

Common misconceptions people might have with the SCAN Formula include: thinking the SCAN is case-sensitive; thinking that SCAN will find partial words; or thinking that the SCAN formula cannot find duplicate values in a range.

How To Actually Use SCAN() in Sheets

SCAN(initial_value, array_or_range, LAMBDA)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the SCAN() formula:

Generate a SCAN() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.