No, because we now have a fuzzy match option in Power Query. This is where we realize we have to manually match our products from the two lists and eventually we give up and start to cry! Right?
We can't even use wildcards in a lookup function because the product names aren't different in a predictable way.
This means we can't just use a lookup function because we don't have exact matches. But each company might have slightly different names for the same item. Our job is to match products between the two lists. Imagine this. We have been given a list of products from company A and a list of products from company B.
