Excel Function

XLOOKUP

Modern lookup function with flexible matching.

XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found])

Arguments

lookup_value

Required

Enter the value you want to look up.

lookup_array

Required

Specify the row/column range where the lookup key is searched.

return_array

Required

Specify the range to return when a match is found.

if_not_found

Optional

Specify the value returned when no match is found.

Practice Preview

return the value that matches a lookup key. Use XLOOKUP to Modern lookup function with flexible matching. For range arguments, drag from the start cell to the end cell in the same argument field, or click start and end cells in order. For lookup_value, enter the value to search and set the related reference ranges. use "N/A" for if_not_found. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=XLOOKUP(B2, B2:B8, D2:D8, "N/A")

Practice This Function

Practice in Sequential Mode Back to Function List