vlookup or indexmatch on closest name match?

hello

having some trouble trying to do a vlookup or index match.

i have a list of ~2000 companies (worksheet Hoovers). Im trying to do a vlookup or match to try to see how many of our ppl are targeting those companies (from worksheet my List).

i tried the vlookup formula (column P in Hoovers sheet):
=VLOOKUP(B2,'My List'!$D$3:$E$1274,2,TRUE)
the above is finding the wrong match

can someone pls help? basically im trying to match the names of the companies and their may not be exact matches
for example:
in the "hoovers" worksheet this company is called: "Exxon Mobil Corporation"
in the "my list" worksheet the comany above goes by: "Exxon Mobil"

can someone pls help?

thx u *i have attached a sample*