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:
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