FALSE

FALSE is a constant function returning the logical value FALSE with no arguments required. It is used to provide an explicit Boolean FALSE as an argument — such as the range_lookup argument in VLOOKUP for exact match — or to store a default false flag in cells consumed by logical formulas.

Excel

=VLOOKUP(A2,C2:D5,2,FALSE())

Google Sheets

=VLOOKUP(A2,C2:D5,2,FALSE())

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

How it works

1Use FALSE() wherever a formula needs a literal Boolean FALSE — the most common case is =VLOOKUP(lookup,table,col,FALSE()) for an exact match.
2Compare against FALSE() in conditionals: =IF(A2=FALSE(),"Off","On") to label Boolean-value cells.
3Note that typing FALSE directly (without parentheses) works in most spreadsheet engines — FALSE() with parentheses is equivalent.

Need a version for your data?

Try: “Set the VLOOKUP match type to exact match using FALSE”

IF IFERROR IFS

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026

FALSE

Try it with your data

How it works

Related