a | b | c | d | e | f | |
1 | dog | dog1 | dog 2 | dogs | Dogs | |
2 | cat | cats | cat1 | cat 2 | Cat | |
3 | hamster | hamsters | hamster1 | hamster 2 | hamster | |
4 |
<tbody>
</tbody>
I was hoping the Excel guru's on this forum can assist me with my issue.
I currently have the above worksheet. Table would be defined as A1:D3. I'm looking for a formula to put in cell F1 that will take the value of cell E1 (which is "Dogs"), and look for a partial match in table A1:D3 (look for any instance that might have "Dogs", an return the corresponding value of column A. So looking for cell E2- instances of "Dogs", it would cell D1 ("dogs") and return cell A1 - "dog"
thank you in advance for the help!