I'm having a group of keywords which I want to match with in particular text.
Below is the example.
<colgroup><col><col></colgroup><tbody>
</tbody>
Here I am writing my function to get the matching result. "=LOOKUP(2^15,SEARCH(fruit,A3),fruit)" where fruits : apple, banana, watermelon & cherry.
Question: Is there anyway to write a function so that I can get the first fruit name appearing in list (Bold fruit name)?
Below is the example.
<colgroup><col><col span="3"></colgroup><tbody> </tbody> |
<colgroup><col><col></colgroup><tbody>
</tbody>
Here I am writing my function to get the matching result. "=LOOKUP(2^15,SEARCH(fruit,A3),fruit)" where fruits : apple, banana, watermelon & cherry.
Question: Is there anyway to write a function so that I can get the first fruit name appearing in list (Bold fruit name)?