[Solved] auto-update data from one sheet to the next using XLOOKUP

[atarahjc7]

Hi! I'm hoping someone can assist me. I have a spreadsheet my boss wants me to add XLOOKUP to. I'm unsure how to use XLOOKUP just yet, but basically, he wants us to be able to take new employee data from one sheet and auto update it into our cross-training matrix.

 

[shamimarita]

Hi! I'm hoping someone can assist me. I have a spreadsheet my boss wants me to add XLOOKUP to. I'm unsure how to use XLOOKUP just yet, but basically, he wants us to be able to take new employee data from one sheet and auto update it into our cross-training matrix.

You can follow these articles of XLOOKUP:
How to Use the XLOOKUP Function in Excel
How to Use XLOOKUP Function with Multiple Criteria in Excel
Hopefully, this article will help you to use the XLOOKUP function. If you face further problems feel free to share.

N.B: Please upload your sample dataset to get the best possible solution.

 

[atarahjc7]

You can follow these articles of XLOOKUP:
How to Use the XLOOKUP Function in Excel
How to Use XLOOKUP Function with Multiple Criteria in Excel
Hopefully, this article will help you to use the XLOOKUP function. If you face further problems feel free to share.

N.B: Please upload your sample dataset to get the best possible solution.

I will take a look at them. Thank you so much!