For example, suppose you have a list of products in column A (A2:A5) and their corresponding prices ... Excel's HLOOKUP ...
Its purpose is to get the product from matching records and return ... the laptop that is greater than a hundred. In the criteria table under the column Quantity, enter >100.