A shopkeeper creates an Excel sheet to list different items he sold today.Rows A1 to A3 contain headings-Order ID,Selling price,and Quantity,respectively.Cells B1 to H1 list the order ID for the items sold-1001,1002,1003,1004,and 1005,respectively.Cells B2 to H2 list their respective selling price-$10,$12.5,$14,$7.5,and $8.Cells B3 to H3 list their respective quantities-10,12,6,5,and 13.If he enters the formula in cell J1 as: =HLOOKUP (1004,A1: H3,2,FALSE),what will the formula return?
A) 5
B) $7.50
C) $12.50
D) 1002

Question

Quizplus · Accepted Answer

The HLOOKUP function searches for a value in the first row of a table or array and then returns a value in the same column from a specified row. In this case, the formula searches for the order ID 1004 in the range A1:H3 and returns the value in the second row of the matching column, which is the selling price of the item with the order ID 1004. Therefore, the formula will return $7.50.

A Shopkeeper Creates an Excel Sheet to List Different Items