Hello. To keep it simple, if column A contains the letters A-C and column B contains strings, how do I return the correct letter (B) in the cell ??? (D1) when I type dog into C1 please? I believe I need to use an array formula containing SEARCH, INDEX and MATCH. I have to use a formula in this instance, VBA is no good. Can you help please?
<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>
Thanks so much for your time.
A | There's a cat in here somewhere | cat | ??? | |
B | There's a dog in here somewhere | |||
C | There's a fish in here somewhere |
<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>
Thanks so much for your time.