T2

= VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

VLOOKUP function

Looks in the first column of an array and moves across the row to return the value of a cel

HLOOKUP function

Looks in the top row of an array and returns the value of the indicated cell

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

XLOOKUP function

Searches a range or an array, and returns an item corresponding to the first match it finds.

Looks up values in a vector or array

LOOKUP function

XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])

XMATCH function

Returns the relative position of an item in an array or range of cells.