CODEWITHSUNDEEP
excel
user1013095
user1013095

Reputation: 11

In Excel, how do I determine if a specific cell with multiple values contains a specific value?

I have a cell that contains multiple values separated by commas (eg. 8,13,27,45). I want to return a value such as TRUE or "X" if that cell contains a given value. For instance, in the above example, if I want to determine if that cell contains a value of 1, it would return FALSE or " ". If I want to determine if I contains the value 13, it would return TRUE or "X". Any thoughts?

Upvotes: 1

Views: 963

Answers (1)

Alex K.
Alex K.

Reputation: 175766

As a formula, adding trailing-leading , to mark delimiters so exact matches work;

=IF(ISERR((SEARCH(","& "what_to_find" &",",","& A1 &","))), "FALSE", "TRUE")

Upvotes: 2

Related Questions