Excel XLOOKUP can be used to search an array for a specific value and returns the value in the same row from another array.