Excel HLOOKUP Example
- "Widget" - this HLOOKUP function is looking for the price of Widgets.
- $D$3:$G$4 - it is looking for this information in the data table located in cells D3 to G4.
- 2- HLOOKUP is looking for the price in the second row of the table.
- False - indicates that only an exact match to the lookup _value "Widget" will be accepted.
The HLOOKUP function returns the results of its search - $14.76 - in cell D1.