The XLOOKUP function returns the values in the result range based on the position where a match was found in the lookup range.
XLOOKUP function - Google Docs Editors Help
This summary was compiled by our editorial team from publicly available information for quick reading. For full details, refer to original reporting where available.