Determine if a value is in a range

To determine if a value is in a column you can use the COUNTIF function


Will display TRUE if the value in cell B1 is in column A and FALSE if it isn’t.

You can use the above as a logical test in an IF function as well.

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.