Printing a person's name if a company name matches approximately.

[jsiu4]

I've been really frustrated trying to look up (oh god no pun intended) how to do this. I'm trying to do something so simple to understand but I'm having such a hard time trying to get Excel to understand what I want. Basically, I have 2 excel sheets. What I need to do is fill a contact list of people based on the company name. In the contact list that I'm filling out, column D is the company name, and I'm trying to fill column I with contact names that are in another sheet. On the second sheet the company names are in column C and the full names are in column A (if any of that matters). The company names is all that I have to work with and they're not exact . If I could get maybe the first 4 letters to match then print the name corresponding to the company name on a different column, this will make my life a lot easier and I could manually fill the remaining empty cells.

I also need to fill out Contact position, phone, and email but I think that if we can get the name to the corresponding company, I'll be able to figure out how to populate the other information.

 

[etaf]

how many characters re likely to match

The ABC company
ABC UK
ABC Inc
ABC Company
ABC Bros ltd
UK ABC chartered surveyors

maybe difficult to match up

there is a fuzzy logic addin for excel
https://www.microsoft.com/en-us/download/details.aspx?id=15011

you may also use a wildcard match

=MATCH("*"&LEFT(table1!A2,5)&"*",Table2!A2:A100,0)

will look at the first 5 characters table1 and try and match to anywhere in table and return the reference - BUT only the first it finds, not multiple entries