How to use HLOOKUP Function in Excel

HLOOKUP Function in Excel stands for “Horizontal Lookup.” This function searches for a specific value in a row to return a value from a different row from the same column.

The HLOOKUP function looks like this:
=Hlookup(lookup_value, table_array, row_index, [range_lookup] )

An HLOOKUP function has four parameters:

Lookup value: The value you need to lookup.

Table Array: The range from where you want to find your value. It could be a table also. Remember your lookup value must be in the first row. So, start the range by keeping the value you want to find in the first row.

Row index: This is the row number from which you want to retrieve data.

Range lookup: this is an optional argument. You need to confirm if you want an exact match or approximate match. The Default here is TRUE, which indicates an approximate match. If you need an exact match, then select FALSE.

#Hlookup #Function #Excel

Thanks for watching.
----------------------------------------------------------------------------------------
Support the channel with as low as $5
[ Ссылка ]
----------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
[ Ссылка ]

Here goes the most recent video of the channel:
[ Ссылка ]

Playlists:
Advance Excel Tutorial: [ Ссылка ]
Excel Tutorial for Beginners: [ Ссылка ]
Excel Case: [ Ссылка ]
Combine Workbook & Worksheets: [ Ссылка ]
All About Comments in Excel: [ Ссылка ]
Excel VBA Programming Course: [ Ссылка ]

Social media:
Facebook: [ Ссылка ]
Twitter: [ Ссылка ]
Blogger: [ Ссылка ]
Tumblr: [ Ссылка ]
Instagram: [ Ссылка ]
Hubpages: [ Ссылка ]
Quora: [ Ссылка ]
Website: [ Ссылка ]

свернуть