Index match - V look up....

[wmtsub]

Not sure witch feature I should try to learn.
I have a spreadsheet with 500+ accounts.
And a second spreadsheet with 338 accounts.

I would like to match the company names form both sheets and if they do cut/copy ten columns from sheet two into sheet 1 for that company.

I am also concerned as to possible misspelling like AAA paint or A.A.A. Paint or possibly bob car vs bobs cars llc.
Is there away I can protect against that being an omission?

 

[mole999]

you can use TRIM to reduce issues with spaces

double minus if you are expecting numbers but they are stored as text

use vlookup if you only want to return the first answer from a list