How it’s written=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
lookup_valueThe value to find, such as a product ID.table_arrayThe table to search. The lookup column must be its first column.col_index_numWhich column of the table to return, counting from 1.range_lookupOptional. Use FALSE for an exact match. Leaving it out means approximate match.
10 points for a first try without hints, 5 otherwise.
