Forum Discussion
How can this formula return multiple matches instead of just 1?
Hi all, I have a formula that searches another worksheet and only returns the first exact match. How can it be edited to return ALL exact matches? This is the formula: =IFERROR($F5&": "&TE...
Has this already been asked?
Formula for returning multiple exact matches - Microsoft Community Hub
And before you ask, the formatting on my end is not the problem. I've double checked everything on my end, the $ are exactly where they need to be in the formula. Not sure why its not searching everything properly as it should be doing. I am using excel on an android tablet by the way.