Microsoft Excel Functions & Formulas

Use the HLOOKUP function to determine sales

and costs of a team

The costs and sales of a team have to be looked up in a table. Each

team is listed by column with its costs and sales. To get the desired

information, use the HLOOKUP function, which searches for a

value in the top row of a table or an array of values, and then

returns a value in the same column from a row that is specified in

the table or array.

HLOOKUP(lookup_value, table_array, row_index_num,

range_lookup)

lookup_value: The value to be found in the top row of the table.

table_array: A table in which data is looked up.

row_index_num: The row number in table_array from which the

matching value ...