Forever_EX
New Member
- Joined
- Mar 26, 2018
- Messages
- 22
I have a macro that searches one of my sheets in excel, let's call the sheet "Keywords". After searching it returns the matches. The Keywords sheet has a bunch of terms like "dog", "small", "big dog", "small white dog", etc.
The problem I am having, and wondering if there is a way to teach Excel what I want... Let's say I write "big dog" and run my macro. It returns "dog" and "big dog". But if I wrote "big white dog" it won't return the keyword "big dog", I guess because the words aren't exact matches.
And, if I wrote "white small dog" it won't return the keyword "small white dog", and I really need to see these close iterations of the words I'm using without memorizing how the terms are presented on the list.
Any help or resources to put me in the right direction?
The problem I am having, and wondering if there is a way to teach Excel what I want... Let's say I write "big dog" and run my macro. It returns "dog" and "big dog". But if I wrote "big white dog" it won't return the keyword "big dog", I guess because the words aren't exact matches.
And, if I wrote "white small dog" it won't return the keyword "small white dog", and I really need to see these close iterations of the words I'm using without memorizing how the terms are presented on the list.
Any help or resources to put me in the right direction?