Google Sheets: How to Check if Value is in Range


You can use the following formulas to check if certain values exist in a range in Google Sheets:

Method 1: Check if Value is in Range

=IF(ISERROR(MATCH("Value to Find", A1:A16, 0)), "Not Found", "Found")

Method 2: Count Occurrences of Value in Range

=COUNTIF(A2:A16, "Value")

Method 1: Check if Value is in Range

The following screenshot shows how to check whether or not the team name “Suns” is found in a certain range of team names:

Google Sheets check if value exists in range

The team name exists in the range, so the MATCH() function returns “Found.”

Note that we can replace “Found” and “Not Found” with numerical values like 1 and 0 if we’d like:

The value 1 indicates that “Suns” was found in the range of team values.

Method 2: Count Occurrences of Value in Range

We can use the COUNTIF() function to find the number of times that a certain value occurs in a range:

We can see that the team name “Suns” occurs 3 times in the range.

Additional Resources

The following tutorials explain how to to perform other common operations in Google Sheets:

Google Sheets: How to Use COUNTIF with Multiple Ranges
Google Sheets: How to Use COUNTIF From Another Sheet
Google Sheets: How to Use SUMIF with Multiple Columns

Leave a Reply

Your email address will not be published.