=INDEX(B:B,MATCH("*Stacy*",A:A,0))
What if instead of Stacy I reference cell C1? When I made the change if failed. BUT your original formula works when applying StacyExcel Formula:=INDEX(B:B,MATCH("*Stacy*",A:A,0))
Assuming you are looking at data in column A and want to return the corresponding row of column B.
Always ask the question you actually want to ask. You'll get the right answer the first time.What if instead of Stacy I reference cell C1? When I made the change if failed. BUT your original formula works when applying Stacy
=INDEX(B:B,MATCH("*" & C1 & "*",A:A,0))