tradeaccepted
New Member
- Joined
- Jun 11, 2013
- Messages
- 33
Hello,
I am trying to use INDEX/MATCH with LEFT, to change the returned value.
Example:
<tbody>
</tbody>
=INDEX(B:B,MATCH(5,A:A,0))
This Formula returns the value of Apples {are great}.
Lets say the INDEX/MATCH formula above is in cell C2. I can run the following formula on cell C2 to return only Apples. =LEFT(H2,FIND("{",C2)-1).
How can I combine these two formulas, so that I have only one formula that returns the value of only "Apples"?
I am trying to use INDEX/MATCH with LEFT, to change the returned value.
Example:
Data1 | Data2 |
5 | Apples {are great}<are good=""></are> |
10 | Oranges {are also great}<are also="" good=""></are> |
<tbody>
</tbody>
=INDEX(B:B,MATCH(5,A:A,0))
This Formula returns the value of Apples {are great}.
Lets say the INDEX/MATCH formula above is in cell C2. I can run the following formula on cell C2 to return only Apples. =LEFT(H2,FIND("{",C2)-1).
How can I combine these two formulas, so that I have only one formula that returns the value of only "Apples"?
Last edited: