Forum Discussion

Cmoreno89's avatar
Cmoreno89
Brass Contributor
Oct 07, 2023

Re: Formula for returning multiple exact matches

Oh and we are looking for EXACT matches only. And if there are no matches, I'd like it to return:
"$F5: N/A"

And if there are multiple matches, I'd like it to return each match like this:
"$F5: <cell number found>; <cell number found>; <cell number found>; - <search phrase>"

Hope that makes sense. If you have any other questions please ask. Thanks!
No RepliesBe the first to reply