How to use HLOOKUP function in Microsoft Excel?

Looks for an incentive in the best line of a table or a variety of qualities, and afterward restores an incentive in a similar section from a column you indicate in the table or cluster.

Utilize HLOOKUP when your examination esteems are situated consecutively over the highest point of a table of information, and you need to look down a predetermined number of lines. Utilize VLOOKUP when your examination esteems are situated in a section to one side of the information you need to discover.

 

The H in HLOOKUP remains for “Even.”

 

Visit here to install office 365 setup

 

Syntax

 

HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

The HLOOKUP work grammar has the accompanying contentions:

 

Lookup_value

 

Required. The incentive to be found in the primary column of the table. Lookup_value can be an esteem, a reference, or a content string.

 

Table_array

 

Required. A table of data in which information is gazed upward. Utilize a reference to a range or a range name.

 

  • The qualities in the principal line of table_array can be content, numbers, or sensible qualities.
  • In the event that range_lookup is TRUE, the qualities in the principal line of table_array must be submitted in climbing request: …- 2, – 1, 0, 1, 2,… , A-Z, FALSE, TRUE; generally, HLOOKUP may not give the right esteem. On the off chance that range_lookup is FALSE, table_array does not should be arranged.
  • Capitalized and lowercase content are identical.
  • Sort the qualities in climbing request, left to right. For more data, see Sort information in a range or table.

 

Row_index_num

 

Required. The line number in table_array from which the coordinating worth will be returned. A row_index_num of 1 restores the principal push an incentive in table_array, a row_index_num of 2 restores the second line an incentive in table_array, et cetera.

In the event that row_index_num is under 1, HLOOKUP restores the #VALUE! blunder esteem; if row_index_num is more noteworthy than the quantity of columns on table_array, HLOOKUP restores the #REF! mistake esteem.

 

Range_lookup

 

Discretionary. A consistent esteem that determines whether you need HLOOKUP to locate a correct match or a rough match. Assuming TRUE or precluded, a rough match is returned.

As it were, if a correct match isn’t discovered, the following biggest esteem that is not as much as lookup_value is returned. Assuming FALSE, HLOOKUP will locate a correct match. On the off chance that one isn’t discovered, the blunder esteem #N/An is returned.

 

Visit here to get office 365 product key.

 

Remark

 

  • On the off chance that HLOOKUP can’t discover lookup_value, and range_lookup is TRUE, it utilizes the biggest esteem that is not as much as lookup_value.

 

  • On the off chance that lookup_value is littler than the littlest incentive in the principal line of table_array, HLOOKUP restores the #N/A mistake esteem.

 

  • On the off chance that range_lookup is FALSE and lookup_value is content, you can utilize the special case characters, question mark (?) and reference mark (*), in lookup_value. A question mark coordinates any single character; an indicator coordinates any arrangement of characters. In the event that you need to locate a genuine question mark or reference mark, type a tilde (~) before the character.

 

For more details, visit : HLOOKUP function

 

Leave a Reply

Your email address will not be published. Required fields are marked *