Under Construction

Syntax:  

=XLOOKUP(lookup, lookup array, return array, [not found], [match mode], [search mode] 

Arguments:

Lookup - The value that you want to compare to another spreadsheet

Lookup Array - The column or row you want to search to find the match

Return Array - What cell value you want Excel to return when it finds a match

Not Found - Optional field... what you want Excel to return if it doesn't find a match

Match Mode - Optional field... 0=exact match (default), 1=exact match or next larger, -1=exact match or next smallest, 2=wildcard match

Search Mode - Optional field... 1=search from the top or beginning (default), -1 = search from bottom or end, 2 = binary search ascending, -2 = binary search descending