In Google Sheets, there’s a handy function that allows you to check if a single value exists in a range of cells. It might seem like a simple task, but it can be quite tricky for some people. Don’t worry, though—I’ve got you covered with this step-by-step guide.
Check a Single Value in a Range of Cells in Google Sheets – How to?
First, take a look at the image below:
Let’s say you want to find out whether the item “Coverall” is present in the list. While you can use the IFS function, it can be a bit lengthy. I have a simpler solution for you. You can use the COUNTIF function in Google Sheets to achieve the same result.
Here’s the formula you can use:
=COUNTIF(B5:B15,C6)In this formula, B5:B15 represents the range of cells you want to search, and C6 is the value you want to find. The formula will return 1 if the value is present in the range, and 0 if it’s not. Based on this, you can further develop your formula for different calculations.
For example, you can use the IF function to perform different actions based on whether the value exists or not. Take a look at the following formula:
=IF(COUNTIF(B5:B15,C6)=1,"This value is existing", "Not in this list")The above formula will return “This value is existing” if the search value is present in the range. You can use this approach for various calculations like pricing, custom messages, or any other calculations you need.
The COUNTIF function is not the only way to check a single value in a range of cells in Google Sheets. You can also use other functions like MATCH or REGEXMATCH (for case-sensitive matches) to achieve similar results.
I hope you find this quick Google Sheets tutorial useful. If you want to learn more about Google Sheets and other tips and tricks, be sure to check out Crawlan.com. Happy spreadsheeting!
