How it’s written=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found])
lookup_valueThe value to find.lookup_arrayThe column or row to search.return_arrayThe column or row to return a value from.if_not_foundOptional. What to show when nothing matches.
10 points for a first try without hints, 5 otherwise.
