Looking up data / matching data

Hi, we are looking to match up some records that maybe already in our CRM. Please see attached datasheet.
To reimport these contacts we need to have the exact name that we have in our CRM against the information in Tab 2.
We need to look up Column B in Tab 2 against the names in Column D of Tab 1 to see if there is a match and add the data from Tab 1 to the data in Tab 2 (Column A - CRM Account Name )