The function XLOOKUP allows you to lookup a specific value from a range and returns the corresponding item from a second range.
Syntax:
=Xlookup(lookup value, lookup range, return range)
Lookup value. Is the value that wanted to be found.
Lookup range. Is the range where we will search for the lookup value.
Return range. Is the range that contain the values to be return when the lookup value is a match.
Syntax with optional arguments
=Xlookup(lookup value, lookup range, return range, value if not found, ,match mode, search mode)