XLOOKUP

Syntax

=ÇAPRAZARA(lookup; lookup_array; return_array; [not_found]; [match_mode]; [search_mode])

Description

Searches a range or an array and returns the corresponding match.

Related Functions