Answer: HLookup
Step-by-step explanation:
HLookup is a function in Microsoft Excel that is part of the Lookup functions, that is, it is used to lookup a value from another table or cell so that it reflects in the desired table.
The “H” in the HLookup stands for Horizontal, that is Horizontal Lookup.
The HLookup function works by looking for a value in the top row of a table or array of values and returning the value in the same column from a row that is specified.
The function is;
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
So, to extract our shipping value from the lookup table, we use the formula;
=HLOOKUP(C2,$B$11:$E$12,2)