Hello Everyone..
I am trying to map two lists (1-o-1 matching). With the help of functions/formulae, i am able to achieve this text matching to some extent..but there are cases where i am failing miserably. Have uploaded the file to get a better picture of what i am trying to do. Any help is...
Hello,
Thanks a lot. This should help...but the main problem arises when i try to map column C ( list 1 clean) to List 2 ( column B)...for example, if i choose to approximate match 'tea-l5603' in list 1 clean, i get an error output. It is mapping neither to 'Bus tea' nor 'per tea' in list 2. I...
Hi,
I have two lists to map..
For example,
List 1 List 2
Bulk/Water All Other Isotonic Beverages
ENHANCED BEVERAGES Per tea
ISOTONIC BEVERAGES Bus tea
KIDS DRINKS Bulk water
MULTI_SERVE_JUICE Multi serve...