Excel FunctionsLesson 84Free preview
HLOOKUP
This lesson is part of Excel · All levels
Summary
HLOOKUP is an Excel search function that searches for values on the first row of a horizontal table and returns values from a particular row below it. The syntax is. This function is suitable for tables whose column headings are in the first row.
Key points
- HLOOKUP searches horizontally on the first row of the table
- Row_index_num specifies which row the value is taken from
- Range_lookup FALSE for exact search, TRUE for estimate
- The search value should be on the first line, not the first column.
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.