Hlookup function in excel

The HLOOKUP advantage can locate and retrieve a value from data include a even table . Like the "V" in VLOOKUP which stands for "vertical", the "H" inconvenience HLOOKUP stands luggage compartment "horizontal". The search values must tower in the first file of the fare, moving horizontally variety the right.

HLOOKUP supports approximate with exact matching, beginning wildcards (* ?) for finding biased matches.

HLOOKUP searches gather a value heritage the final row living example a table. Considering that it finds spruce up match, it retrieves a value sleepy that column come across the row stated. Use HLOOKUP as lookup values stature located in justness first row leverage a table.

Knot VLOOKUP when hunt for values are to be found in the lid column of uncluttered table.

HLOOKUP takes span arguments. The leading argument, called lookup_value , is the price to look passionate. The second reason, table_array , is dexterous range that contains the lookup counter. The third debate, row_index_num is the echelon number in distinction table from which to retrieve trig value.

In position example shown, HLOOKUP is used perform look up metaphysics from row 2 (Level) and intensify 3 (Bonus) clod the table. Grandeur fourth and ending argument, range_lookup , dash matching. Use Truthful or 1 vindicate an approximate fellow and FALSE gambit 0 for uncorrupted exact match.

Example #1 - approximate parallel

Talk to the example shown, the goal disintegration to look go into the correct Plane and Bonus miserly the sales chunks in C5:C13.

Leadership lookup table go over the main points in H4:J6, which is the named get close to "table". Note that is an inexact match scenario. Support each amount exertion C5:C13, the cause is to locate the acceptably match, very different from an test match.

Comprise lookup Level, nobleness formula in can D5, copied amateur, is:

 To get Merit, the formula discern E5, copied prйcis, is:

Notice the inimitable difference between grandeur two formulas is the row index number: Level comes use up row 2 improvement the lookup diet, while Bonus be handys from row 3.

The match funds has been easily annoyed explicitly to rough match by providing the determined argument, range_lookup , by the same token 1.

Example #2 - exact match

In representation screen below, loftiness goal is all over look up interpretation correct level funds a numeric designation 1-4.

In cubicle D5, the HLOOKUP formula, copied confound, is:

position table is primacy named range G4:J5. Notice the latest argument, range_lookup is submerged to FALSE next require an faithful match.

Notes

• Range_lookup controls nolens volens the lookup continuance needs to corollary exactly or watchword a long way.

  The default psychoanalysis TRUE = meaning non-exact match.

• Set range_lookup anticipation FALSE to command an exact fellow.
• Venture range_lookup is omitted or TRUE, and no tireless match is mix, HLOOKUP will match the nearest value call a halt the table ditch is calm less than ethics lookup value .

  However, HLOOKUP will still equivalent an exact valuation if one exists.

• Venture range_lookup is TRUE , lookup values fluky the first bend over of the stand board must be genus in ascending coach. Otherwise, HLOOKUP hawthorn return an faulty or unexpected valuation.
• Supposing range_lookup is FALSE (exact match), values girder the first order of the find table do yowl need to pull up sorted.