Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to check if a value exists in a list in Excel and Google Sheets
Excel & Google Sheets
=COUNTIF(B2:B4,A2)>0✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Find | List |
| Bob | Alice |
| Bob | |
| Carol |
=COUNTIF(B2:B4,A2)>0→TRUE
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
Runs server-side · free · no signup
Step by step
- 1Put the value you want to find in cell A2, and the list to search in B2:B20.
- 2Use =COUNTIF(B2:B20,A2)>0 — returns TRUE if the value is found, FALSE if not.
- 3Alternatively, use =ISNUMBER(MATCH(A2,B2:B20,0)) — MATCH finds the position (a number) if found, and ISNUMBER converts it to TRUE/FALSE.
- 4Wrap in IF for a label: =IF(COUNTIF(B2:B20,A2)>0,"Found","Not Found").
Tips
- COUNTIF with wildcards lets you do partial matching: =COUNTIF(B2:B20,"*"&A2&"*")>0 returns TRUE if A2 appears anywhere within any cell in the list.
Need it for your exact data?
Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.
Frequently asked
Which is better: COUNTIF or MATCH for checking existence?
Both work — COUNTIF is simpler and more readable. MATCH is useful when you also need the position of the found item, not just whether it exists.
How do I check if ANY value from one list exists in another list?
Use =SUMPRODUCT(COUNTIF(list1,list2))>0 — it returns TRUE if at least one item from list2 appears in list1.