Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
55
Views
Topic starter
Hello,
I'm using xlookup to categorise my transactions but I'm having troubles with finding keywords in a cell because there are many other words en numbers in it.
So it isn't an exact match, and that's the problem.
See the example....
Regars,
Alain
Posted : 14/04/2020 7:31 am
Hi Alain,
You can do this with a combination of INDEX, SUMPRODUCT and SEARCH. There's a blog post on how it works here
Search a String for a List of Words in Excel
The attached file has this working formula in it.
Regards
Phil
Posted : 14/04/2020 8:39 am
