connecting two sheets based on a common field

I have two sheets, one containing employee name and their associated organizations (clients) and the other containing organization performance data. Both sheets have the field organization id. Is there a way for me to add the employee name column to the performance data in a way that automatically assigns the correct employee based on organization ID?

nshatz_mockdata.zip

Thanks!

Thank you sir - solution and advice.