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 ...
Cmoreno89
Oct 08, 2023Brass Contributor
It's sensitive information, I can't share the exact details as far as data goes.
But essentially, it's a workbook with multiple worksheets.
The worksheet names are manually typed into range $F5:$F35.
The search phrases are in range $G5:$G100.
But all we're looking to do at this point is start by searching for the first search phrase, which is cell $G$5. (I will gladly manually edit each formula for the other search phrases later).
But first we need a working formula for the first search phrase, which is in cell $G$5.
And we are only searching the A columns of each worksheet. No other columns.
Thats pretty much it!
But essentially, it's a workbook with multiple worksheets.
The worksheet names are manually typed into range $F5:$F35.
The search phrases are in range $G5:$G100.
But all we're looking to do at this point is start by searching for the first search phrase, which is cell $G$5. (I will gladly manually edit each formula for the other search phrases later).
But first we need a working formula for the first search phrase, which is in cell $G$5.
And we are only searching the A columns of each worksheet. No other columns.
Thats pretty much it!
peiyezhu
Oct 08, 2023Bronze Contributor
How about remove sensitive information or provide dummy data?
In fact,I can not figuare out your specific problem without Excel file.
Additionally,
If formula not available,how about web service ?
In fact,I can not figuare out your specific problem without Excel file.
Additionally,
If formula not available,how about web service ?