Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to get last column number in range in Excel
  • How to use Excel MATCH Function
  • Basic INDEX MATCH approximate in Excel
  • Vlookup Examples in Excel
  • How to use Excel INDIRECT Function

Data Analysis Examples

  • Understanding Anova in Excel
  • How to Use Solver Tool in Excel
  • Filter Data Based on Date in Excel
  • How to Create Column Chart in Excel
  • How to create Checklist in Excel

Data Validation Examples

  • Excel Data validation allow uppercase only
  • Excel Data validation date in specific year
  • Excel Data validation require unique number
  • Excel Data validation whole percentage only
  • Excel Data validation must not contain

How to use Excel HLOOKUP Function

by

This Excel tutorial explains how to use the HLOOKUP function with syntax and examples. How to handle errors such as #N/A and retrieve the correct results is also discussed.

Excel HLOOKUP function Description

The Microsoft Excel HLOOKUP function performs a horizontal lookup by searching for a value in the top row of the table and returning the value in the same column based on the index_number.

Worked Example:   Get first text value with HLOOKUP in Excel

The HLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function. HLOOKUP function can be entered as part of a formula in a cell of a worksheet.

Worked Example:   Excel VLOOKUP and HLOOKUP functions Examples

Explanation: The above HLOOKUP examples would return:

=HLOOKUP(10251, A1:G3, 2, FALSE)
Result: $16.80    'Returns value in 2nd row

=HLOOKUP(10251, A1:G3, 3, FALSE)
Result: 6         'Returns value in 3rd row

=HLOOKUP(10248, A1:G3, 2, FALSE)
Result: #N/A      'Returns #N/A error (no exact match)

=HLOOKUP(10248, A1:G3, 2, TRUE)
Result: $14.00    'Returns an approximate match

Post navigation

Previous Post:

How to use Excel GETPIVOTDATA Function

Next Post:

How to use Excel FORMULATEXT function

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • TRIM function: Description, Usage, Syntax, Examples and Explanation
  • Clean and reformat telephone numbers using SUBSTITUTE function in Excel
  • REPLACE, REPLACEB functions: Description, Usage, Syntax, Examples and Explanation
  • Remove text by variable position in a cell in Excel
  • How to count specific characters in a cell in Excel
  • EOMONTH function: Description, Usage, Syntax, Examples and Explanation
  • Add years to date in Excel
  • Get days between dates ignoring years in Excel
  • How to calculate next scheduled event in Excel
  • Calculate date overlap in days in Excel
  • DURATION function: Description, Usage, Syntax, Examples and Explanation
  • SLN function: Description, Usage, Syntax, Examples and Explanation
  • IPMT function: Description, Usage, Syntax, Examples and Explanation
  • Tax rate calculation with fixed base in Excel
  • How to calculate principal for given period in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles