Lecture 31 - Excel - HLOOKUP Function with (Exact Match and Approximate Match)

Hlookup can be used to lookup exact results or approximate results. This video tutorial in an in-depth guide to how to use the exact match and the approximate match feature of MS Excel HlookupTo watch more

HLOOKUP is an Excel function to lookup and retrieve data from a specific row in table. The "H" in HLOOKUP stands for "horizontal", where lookup values appear in the first row of the table, moving horizontally to the right. HLOOKUP supports approximate and exact matches.

Sometimes we use these functions for an exact match. For example, we're looking up someone's name, or a social security number, or an ID number.That number has to be exact.

Worksheet called ApproximateMatch we're about to use the HLOOKUP function and compare a Salary with the top row of this table over here. That would be using the HLOOKUP function.

What we're about to do here is called an approximate match. We've got some salaries here, we certainly can't list every salary over here in this table. We could theoretically, it would be huge, but the idea here is none of these salaries matches up any of these. Now certainly one of them could, one of them might, but the idea is we're looking up approximate answers here.

Microsoft Excel is a commercial Spreadsheet software designed by Microsoft. It is a component of the Microsoft Office and is often called simply Excel or MS Excel.

VLOOKUP VIDEO SERIES:

1. VLOOKUP Function with (Exact Match and Approximate Match)


2. VLOOKUP Function with TRIM Function and IFERROR Function


3. Nested VLOOKUP Functions


Download the workbook here:


Tags:
hlookup, hlookup function, hlookup in excel, excel hlookup function, hlookup function in excel, how to use hlookup function in excel, lookup,hlookup formula, lookup function, vlookup and hlookup function in excel, lookup function in excel, hlookup function excel 2016, excel,hlookup formula in excel, how to use hlookup formula in excel, using hlookup formula, excle formula hlookup, hlookup excel formula, hlookup with exact match, hlookup with approximate match

hlookup,hlookup function,hlookup in excel,excel hlookup function,hlookup function in excel,how to use hlookup function in excel,lookup,hlookup formula,lookup function,vlookup and hlookup function in excel,lookup function in excel,hlookup function excel 2016,excel,hlookup formula in excel,how to use hlookup formula in excel,using hlookup formula,excle formula hlookup,hlookup excel formula,hlookup with exact match,hlookup with approximate match,