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

atarahjc7

New member
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.
 
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.
 

Online statistics

Members online
0
Guests online
14
Total visitors
14

Forum statistics

Threads
318
Messages
1,408
Members
583
Latest member
mibr fan token
Top