You can follow these articles of XLOOKUP: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.
I will take a look at them. Thank you so much!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.