Staff Skills academy+
Home » Courses » Microsoft Excel for Beginners Certification » Module 18 : HLOOKUP
Module 18 : HLOOKUP
18.1 HLOOKUP in Excel The HLOOKUP function is similar to the VLOOKUP function, but it looks for values horizontally (thus, the H), rather than vertically. HLOOKUP searches for a value in the first row of a table. At the match column, it retrieves a value from the specified row. You use HLOOKUP when you want to search across a row to find a value in a specific column in a table. The formula for the HLOOKUP Function is: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) ...
Lessons
- Module 1 : Introduction to Excel
- Module 2 : Add
- Module 3 : Multiply
- Module 4 : Subtraction in Excel
- Module 5 : Dividing
- Module 6 : Sort
- Module 7 : Percentage
- Module 8 : Running Totals
- Module 9 : Print
- Module 10 : Paste Special
- Module 11 : Merge
- Module 12 : Filter
- Module 13 : AVERAGE
- Module 14 : AVERAGEIF
- Module 15 : SUMIF Formula
- Module 16 : IF Formula
- Module 17 : VLOOKUP
- Module 18 : HLOOKUP
- Module 19 : COUNTIF Formula
- Module 20 : COUNTBLANK
- Module 21 : COUNTA Formula
- Module 22 : COUNT Formula
- Module 23 : CONCATENATE
- Module 24 : TRANSPOSE
- Module 25 : DATE Formula
- Module 26 : MONTH Formula
- Module 27 : Pivot Tables
- Module 28 : Pie Charts
- Module 29 : Doughnut Charts
- Module 30 : Line Charts
- Module 31 : Column Charts
- Module 32 : Bar Charts
- Module 33 : Number Formatting
- Module 34 : Create Borders
- Module 35 : Conditional Formatting
- Module 36: Comments
