Forum Discussion
Cmoreno89
Oct 07, 2023Brass Contributor
Formula for returning multiple exact matches
Hi all, I've been working on a formula for several days now but haven't been able to fully figure it out. ChatGPT helped me get to this point but it can't figure out how to completely solve ...
PeterBartholomew1
Oct 13, 2023Silver Contributor
All I needed was
= HSTACK(data) = target
data
= greece:portugal!$A$2:$A$22but that is not to say it will work for you.