Formulas > =FINDB()

How To Use FINDB() Function in Google Sheets


Returns the position at which a string is first found within text counting each double-character as 2.

Common questions about the FINDB formula:
- What is the syntax of the FINDB formula?
- What are the supported parameters in the FINDB formula?
- How do I reference a spreadsheet cell or range with the FINDB formula?

How can the FINDB formula be used appropriately?
The FINDB formula can be used to search for a given value in a cell range and return either the row or column number of where it appears, depending on the parameters used.

How can the FINDB formula be commonly mistyped?
The FINDB formula can be mistyped if the wrong parameter is used or if the range parameter is wrongly specified.

What are some common ways the FINDB formula is used inappropriately?
The FINDB formula is often used inappropriately for purposes other than its intended purpose, such as when trying to find a string or multiple values in a given cell range.

What are some common pitfalls when using the FINDB formula?
It is important to pay attention to the order of parameters in the FINDB formula and to make sure that the range parameter is correctly specified.

What are common mistakes when using the FINDB Formula?

It is common for users to omit the optional parameters of the FINDB formula or to make syntax mistakes when specifying the range parameter.

What are common misconceptions people might have with the FINDB Formula?
Some people may confuse the FINDB formula with the FIND function, which works slightly differently and does not support the optional parameters that FINDB does.

How To Actually Use FINDB() in Sheets

FINDB(search_for, text_to_search, [starting_at])

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 FINDB() formula:

Top 10 Microsoft Excel Functions -- FIND/FINDB function explained

This short video shows you how to use FIND/FINDB with examples, online documentation and best practices, all in a few minutes!

Generate a FINDB() 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. Free to try for non-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.