Imagine this. We have been given a list of products from company A and a list of products from company B.

Our job is to match products between the two lists. But each company might have slightly different names for the same item.

This means we can't just use a lookup function because we don't have exact matches. We can't even use wildcards in a lookup function because the product names aren't different in a predictable way.

Read Article