need to pull info from 2 different spreadsheets

[dsca]

Hopefully I can explain my situation correctly.
I have two spreadsheet that I need to pull info from for a third spreadsheet

First Spreadsheet:
It's a complete directory of the company's employees and has the following columns -
- Employee Email
- Employee Full Name
- Employee Manager Email
- Employee Manager Full Name

Second Spreadsheet is again complete directory of the company's employees and has the following columns -
- Employee Email
- Employee Full Name
- Employee's Director's Full name

Third Spreadsheet has the following columns for just the Marketing, Legal and Finance department -
- Employee Email
- Employee Full Name
- Employee US location, City
- Employee US location, State

I need to add the following columns to the the third spreadsheet -
- Employee Manager Email
- Employee's Director's Email

Both of these values can be got from the First Spreadsheet.

How do I go about doing this?
Thanks for any help.

 

[Joe4]

Welcome to the Board!

I think you should be able to use XLOOKUP functions to look up the information from the other sheets and return it to your desired sheet.
See here for an explanation and examples on how to use this function: XLOOKUP function - Microsoft Support

 

[alansidman]

Alternatively, you can join the two spreadsheets in Power Query with an Inner Join.