Please see the attached sheet.
I want a formula to find the best (closest) match within a list and return and item code.
Been searching all over the internet and haven't had any luck.
It probably has to be a pretty complex formula for example i want to return "COKE DIET FREE" if the string is "Caffeine Free Diet Coke" or "Caffeine Free Coke Diet".
I hope I explained it well enough....
The worksheet kind of helps..
Thanks in advance.
Bookmarks