Xlookup Excel, the excel function to look up a range or array and then return the item associated with the first match it finds

 

Xlookup is a function in Excel to look up a range or array, and then return the item associated with the first match it finds. If there is no match, then xlookup can return the closest (approximate) match.

Formula:

=XLOOKUP(lookup_value; lookup_array; return_array; [if_not_found]; [match_mode]; [search_mode]) 

Example:

Uses XLOOKUP to look up the names of people in the range, then returns their gender. 

For example the table like this.

So, the formula in the column G2 is 

=XLOOKUP(F2;B2:B6;D2:D6)

If you press Enter in your keyboard. The result like this.

It's easy to use the excel xlookup formula. Happy trying.