Hello, I have two tables (below are examples along with the desired outcome). I'm looking to VLookup across these tables for values that are present in the table it's pulling from and another table. I'm not sure how to go about doing this - lets say that all of the information I have for Supervisor is a name, which is unique, but I need to pull in the supervisor's EEID, Email, and Location. The supervisors are in the EEName column which I'm looking up in. There are expected to be some blanks as certain employees (the CEO) do not report in to anyone.
tblPersonal
EEName EEID Bob 123456 Bob@.com Stan 234567 stan@.com ken 345678 ken@.com lee 456789 lee@.com
tblCompany
EEName Supervisor Location Bob Lee MA Stan Bob CA Ken Lee EU Lee MA
Desired Outcome
Employee Employee ID Email Address Office Location Supervisor Name Supervisor Email Supervisor Office Location Bob 123456 Bob@.com MA Lee lee@.com MA Stan 234567 stan@.com CA Bob bob@.com MA Ken 345678 Ken@.com EU Lee Lee@.com MA Lee 456789 Lee@.com MA