I have 2 excel sheets. The company name field in both differ in most cases.
currently I do a vlookup like this
=VLOOKUP(AH5033,companydetails_company.xls!M$2:M$1 491,1,FALSE)

For example on the first excel sheet I will have: "Greenberg Ltd" and then
on the other sheet I might have "Greenberg Ltd." or "UK Greenberg"

Is there something called a best match? Its a once off thing I need to do
so efficency is not an issue.

I'd really appreciate the help with this one.