Hi all



I need a function where Excel can identify variants of a word. In my example I want Excel to identify the word "1 & OVER" but I have variants of this word like "1 & OVER 1.5", "1 & OVER 2.5", "1 & OVER 3.5" and "1 & OVER 4.5"

I tried to do it by using OR but I had no luck.

Attached Images

2019-01-12_14-14-05.png (38.6 KB, 35 views)

Please post a sample sheet (with expected results) so we can work on it. Pictures are useless. Thanks


You can try something like =IF(ISNUMBER(SEARCH("1 & OVER*",B20),....

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

The easiest way:
1. On separate sheet you need a table, where in left column are all possible values of Bet Types, and in second column value for bet group (in your worksheet values in range G2...?2);
In 1st part of your formula, instead of IF()'s use COUNTIf() or COUNTIFS() to count rows in this table, where the value of 1st column equals with Bet Type in your original table, and the value in second column eguals with value in 2nd row of same column in your original table. And then you check the count - is it 0 (no matches were found) or >0 (at least one match was found).