Forum Discussion
Malfunctional Formula
=IFERROR(INDEX(TRIM(ISNUMBER(SEARCH(A1,A2:A4))), MATCH(B1&"*",B2:B4,0))=TRIM(A1),"TRUE") So B Column is working perfectly. The A column is messing up though. A1=Doreen and A3=Doreen W I'm trying to...
It was for a different file but it worked like a charm. I have 5 different lists im trying to make quick to search but they all have different formats. Most have been easyish but those two had stumped me
Thomas, so far so good. As a comment, asking the question it's always better to attach sample file where possible. You are within your projects and some things which are obvious for you not clear for us. We here could make only the guess and not always correct guess.