Hello everyone,

Here is my task for urgent:

I have to list of companies, but their names are different, I need to match and be sure that the same customer belongs to both tables.

Ex.: ABGO in table one, and ABGO. in table two. If I do a VLOOKUP it doesn’t find because in one there is a (.) and in the other no. How can I do it?
I was thinking about taking part of the text and find in the another table, how is the function to find in another table (I can use mid to extract part of the text)