Variable to excel formula

  • I have an excel formula, which will display the first value related to "RE" that it found.


    Code
    =INDEX(EntryID!C:C,MATCH("RE*"&"*"&C10,EntryID!D:D,0))


    Instead of displaying that, I want it to display the variable, like in C programming.


    Code
    Fruit =INDEX(EntryID!C:C,MATCH("RE*"&"*"&C10,EntryID!D:D,0))


    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?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!