Hi,
I have the following formula:
=IFERROR(INDEX(Sheet1!$A$25:$L$233,SMALL(IF(Sheet1!$E$25:$E$233=$A$1,ROW(Sheet1!$E$25:$E$233)-ROW(Sheet1!$E$24)),ROWS(A$25:A26)),MATCH(A$24,Sheet1!$A$24:$J$24,0)),"")
where A1 is the text I'm trying to match to.
This formula works fine, but I need to find a way to fold in a wildcard, so it picks up any instance of the word in A1. For example, if A1 = Bob, I also want it to return any matches that have Bobby listed.
I've tried folding in "*&A1&*" into the formula as seen below, but it doesn't seem to work.
=IFERROR(INDEX(Sheet1!$A$25:$L$233,SMALL(IF(Sheet1!$E$25:$E$233="*&A1&*",ROW(Sheet1!$E$25:$E$233)-ROW(Sheet1!$E$24)),ROWS(A$25:A26)),MATCH(A$24,Sheet1!$A$24:$J$24,0)),"")
Any ideas would be greatly appreciated!!
Thank you!
Bookmarks