I'm trying to do something simple, yet I can't figure it out.

I have two spreadsheet. One includes company names and "codes":

QWE843 | Apple
FER244 | Dell
RWT224 | HP

and so on.

In another spreadsheet I have a list of people from each company, but
instead of the company name, they have their company code:

QWE843 | Joe Doe
FER244 | Mary Monson
QWE843 | Steve Jobs
FER244 | Donald Duck

What I'd like to do is to add a column with the company names in the second
spreadsheet, taking the first spreadsheet as a reference. So, the end result
would be

QWE843 | Joe Doe | Apple
FER244 | Mary Monson | Dell
QWE843 | Steve Jobs | Apple
FER244 | Donald Duck | Dell

I tried with if, then, if, then... but it's too many parameters (there are
about 300 different company codes). Is this doable?

Thanks!

M.