In my example, I have a column with the names of the signs we produce in our store and I have to be able to isolate similar named signs. Suppose I have to return a value if the cell is Bud Light and only Bud Light among the following:
Bud Light Platinum
Bud Light Lime
Bud Light NFL
Performed more than 100 times at random.
I'm trying to determine the cost of signage and promotions.
Link to the Google card
The sheet above is an example of what I'm trying to do.