Forum Discussion
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 ...
Is there also an alternate formula that calculates faster? It's taking ages to run through everything it seems...
And also, when I copy and pasted the formula down it down into the rest of the F column there were some "#N/A" and "#NUM!" errors. How could this be?
And also, when I copy and pasted the formula down it down into the rest of the F column there were some "#N/A" and "#NUM!" errors. How could this be?
Can you share some data and expected result?
- 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! - 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!- 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 ?
