Forum Discussion
How to search for a cell containing text referenced from another cell
I am looking to find cells based on strings in other cells. Example:
| Range | Search Criteria | Formula | Output |
ugh Help me | 23 | find B2 in A2:A4 | A3 |
| please 23 why | learning | find B3 in A2:A4 | A4 |
| I am learning, I promise | help me | find B4 in A2:A4 | A2 |
What formula should I be using to get the output?
PLEASE AND THANK YOU!
="A"&MATCH("*"&B2&"*",$A$2:$A$4,0)+1You can try this formula which returns the expected result in my sheet.
