Using the information below, answer the question to the right. Which function should you use to extract shipping values from the Lookup Table?

HLookup

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)

these  signals travel  down a part of the neuron called the axon, which is like a wire that carries the  signal  to othernerve  cells. on average a  nerve  cell sends a  signal  at about 50 meters per second, which is over 100  miles  an hour!

english /