simple array formula

[Masha92]

Hello everyone,

Hopefully you can help me with this.

So i have a list of values (not in any cell) that I need to check against a single value.

I want to check if 2 exist in {3,4,6,12,2} and the result would be TRUE or FALSE

My intial statement was =2={3,4,6,12,2} but the results comes in MULTIPLE cells as TRUE and FALSE. I need it to be single cell value.

Can you please help me?

Thank you
Masha

 

[KevCarter]

Does this do the trick?

=OR(2={3,4,6,12,2})

 

[Masha92]

It certainly does!

Brilliant.

I tried sum and countif...etc but nothing worked,

Thank you sir

 

[KevCarter]

It certainly does!

Brilliant.

I tried sum and countif...etc but nothing worked,

Thank you sir

Good deal. Happy I could help!