Forum Discussion
Return the search value
I hope you are fine. I have asked this question twice before, but the answers were not suitable for me. I don't want to do this with Power Query. I want to search all 10064 words in column j in eac...
It might help others to look at solutions offered in other discussions from jorj1991 .
Optimization and efficiency seem to be really important in this setup if previous solutions weren't acceptable. It's not clear if memory errors are the reason those solutions didn't work but I'll suggest that one thing to try with any lookups being done is to clean up and sort the words list in ascending order. Then try a VLOOKUP with an approximate match or even an XLOOKUP with a binary search. The tradeoff is the lookups are not as accurate but may at least calculate.
- Hello, thank you for taking the time to write this answer. I apologize for the delay in answering. It works according to the formulas I have seen.
Thank you dear friend
