How to use Excel HLOOKUP function
All the basic information regarding Excel HLOOKUP function is listed in the table below. (This data is regularly updated from Microsoft and several resources)
|Function Category:||Lookup and reference|
|Description:||Looks in the top row of an array and returns the value of the indicated cell|
|Return Value:||The matched value from a table.|
|Syntax:||=HLOOKUP (value, table, row_index, [range_lookup])|
|Applies to:||Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000|
|Other languages:||English: HLOOKUP
|Portuguese (Brazil): PROCH
Portuguese (Portugal): PROCH
All Other Languages: HLOOKUP
Syntax details with an example regarding the correct usage of function can be seen below.
=HLOOKUP (value, table, row_index, [range_lookup])
|value||The value to look up.|
|table||The table from which to retrieve data.|
||The row number from which to retrieve data.|
|range_lookup [optional]||A boolean to indicate exact match or approximate match. Default = TRUE = approximate match.|
Check the video below to see How to use Excel HLOOKUP function with some examples:
LINKS AND RESOURCES
Here we provide a list of useful links which we think can be useful while trying to learn the function usage with some examples and tips.
Microsoft Office support page – Excel HLOOKUP function:
EXCEL FORMULAS TRAINER
As said: Practice Makes Perfect!
Test your Excel skills in Excel itself with our unique product: Excel Formulas Trainer.
30 sections and around 100 questions with full hands-on experience. Progress tracking, dashboard, error checking and many more. Check it now: