• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to use the Excel HLOOKUP function

HLOOKUP in excel expectations scans for an incentive in the main line of a table. At the match segment, it recovers an incentive from the predefined push. Utilize HLOOKUP when query esteems are situated in the main line of a table. Utilize VLOOKUP when query esteems are situated in the principal segment of a table.


Summary

HLOOKUP is an Excel capacity to query and recover information from a particular line in table. The "H" in HLOOKUP remains for "level", where query esteems show up in the primary line of the table, moving on a level plane to one side. HLOOKUP bolsters inexact and correct coordinating, and special cases (* ?) for discovering incomplete matches.


Purpose

Query an incentive in a table by coordinating on the main column


Return value

The coordinated an incentive from a table.


Syntax

=HLOOKUP (esteem, table, row_index, [range_lookup])


Arguments

esteem - The incentive to gaze upward.

table - The table from which to recover information.

row_index - The line number from which to recover information.

range_lookup - [optional] A boolean to demonstrate correct match or inexact match. Default = TRUE = rough match.



Utilization notes

HLOOKUP scans for an incentive in the primary column of a table. At the match segment, it recovers an incentive from the predefined push. Utilize HLOOKUP when query esteems are situated in the principal column of a table. Utilize VLOOKUP when query esteems are situated in the principal section of a table.



Range_lookup controls whether esteem needs to coordinate precisely or not. The default is TRUE = permit non-correct match.


Set range_lookup to FALSE to require a correct match.


On the off chance that range_lookup is TRUE (the default setting), a non-correct match will cause the HLOOKUP capacity to coordinate the closest incentive in the table that is still not as much as esteem.


At the point when range_lookup is excluded, the HLOOKUP capacity will permit a non-correct match, yet it will utilize a correct match on the off chance that one exists.


In the event that range_lookup is TRUE (the default setting) ensure that query esteems in the main line of the table are arranged in climbing request. Something else, HLOOKUP may restore a mistaken or surprising worth.


In the event that range_lookup is FALSE (require correct match), values in the main line of table don't should be arranged.
 
Top