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...
="A"&MATCH("*"&B2&"*",$A$2:$A$4,0)+1You can try this formula which returns the expected result in my sheet.