Looking up value and filling cells

I have a set of data I'm trying to go through, and my problem is that I can't figure out a quick way to do what I want.
So if you take a look at the attachment, there's the TRI Unique Parent Company Name on the first sheet. I'd like to look up those companys' names in the other sheets (naics 31-33) and if there is a match, then fill in the CUSIP and GVKEY columns.

So originally, I tried using vlookup. The formula I used in that first sheet was

=VLOOKUP(A2, 'naics 31'!A3:I16, 7, FALSE)

but I realized my problem: the contents of cell A2 in the first sheet would have to be the EXACT SAME as the 'match' in the other sheets.

So is there another way I can look for the company name in 'naics 31' without an exact match?
If you can't tell, the reason for this is because most names have a period or 'INC' at the end of their names and so don't match up perfectly with what's on the other sheets.

Thanks