SUMIFS

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

VLOOKUP

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