Hi firuze, A Lookup Table is for exact matches only as you've discovered. However, why not accomplish this via a Conditional Update Rule as described in this post? That way, you can use wildcards as you described. Please let us know how you get on
I made it work by using a combination of both lookup tables and the conditional rule with wild cards.
I managed it through a program to apply the steps; 1st the lookup table rules and 2nd the conditional update rules (for the ones that haven't been captured in the 1st step).
Thank you for the helpful advice!
Great work firuze - I'm glad you got it to work