If there is a unique identifier you might consider using
Where you place the formula in one file and the Key is the common
identifier, Table is the data in the other file (the Key must be found in the
leftmost column of the Table range), Col is the column of the Table you want
to return, counted from left to right in the table range, Type indicates
whether you want an approximate or an exact match, in your case exact, so you
should use False (or 0).
Microsoft Excel MVP