Excel XLOOKUP can be used to search an array for a specific value and returns the value in the same row from another array.
How to use the XLOOKUP function in Excel with 7 Examples!
This summary was compiled by our editorial team from publicly available information for quick reading. For full details, refer to original reporting where available.