# How to use Excel HLOOKUP function

## SUMMARY INFO

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: HLOOKUP 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 French: RECHERCHEH German: WVERWEIS Spanish: BUSCARH Dutch: HORIZ.ZOEKEN Italian: CERCA.ORIZZ Russian:  ГПР Danish: VOPSLAG Swedish: LETAKOLUMN Portuguese (Brazil): PROCH Polish: WYSZUKAJ.POZIOMO Finnish: VHAKU Norwegian: FINN.KOLONNE Portuguese (Portugal): PROCH Czech: VVYHLEDAT Hungarian: VKERES Turkish:  YATAYARA All Other Languages: HLOOKUP Related Functions: VLOOKUP

## FUNCTION DETAILS

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.
row_index
The row number from which to retrieve data.
range_lookup [optional] A boolean to indicate exact match or approximate match. Default = TRUE = approximate match.

## VIDEO EXAMPLES

Check the video below to see How to use Excel HLOOKUP function with some examples:

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: