I have an excel formula, which will display the first value related to "RE" that it found.
Instead of displaying that, I want it to display the variable, like in C programming.
so in the cell, instead of displaying the value from the formula, it will display Fruit instead. This is because I have two wildcards. One is "RE" and it is fixed, the other one depends on the value of column C10.
Is it possible to achieve this?