Futile Crush
New Member
- Joined
- Oct 3, 2009
- Messages
- 45
Hey guys, I wanted to know how to find out if the value in one cell equals any one of an item in a list, without using a tedious OR formula for everything or VBA code. If there's any way to do this, I'd be greatly appreciative for you to let me know. .
Just to clarify, or give an example, say I had the concatenated sentence "RuneScape is awesome" (concatenated from three randomly alternating cells, so the sentence is also randomised.) I want to put a formula next to it that asks if the concatenated cell matches any of the (static) list below, and if so, return TRUE or FALSE. I don't need you to tell me how to do an IF formula as I already know, and if there is any such formula that doesn't require VBA code or tedious copying and pasting into an OR formula, it should hopefully return TRUE/FALSE anyway.
Thanks in advance.
Just to clarify, or give an example, say I had the concatenated sentence "RuneScape is awesome" (concatenated from three randomly alternating cells, so the sentence is also randomised.) I want to put a formula next to it that asks if the concatenated cell matches any of the (static) list below, and if so, return TRUE or FALSE. I don't need you to tell me how to do an IF formula as I already know, and if there is any such formula that doesn't require VBA code or tedious copying and pasting into an OR formula, it should hopefully return TRUE/FALSE anyway.
Thanks in advance.