HLOOKUP waa shaqo ku jirta Microsoft Excel oo ka raadisa qiyamka liiska Horizontal. Shaqada HLOOKUP waxay raadisaa qiyamka Si toos^{(Horizontally)} ah safka sare ee shaxda^(Table) ama Array , waxayna ka soo celisaa qiimaha tiirka isla Shaxda^(Table) ama Array of value, waxayna ka soo celisaa qiimaha safka aad sheegtay. H ee ku jira LOOKUP waxay u taagan tahay jiif. Farqiga u dhexeeya VLOOKUP iyo HLOOKUP ayaa ah in VLOOKUP uu raadiyo tiirar halka HLOOKUP uu raadiyo saf.

Shaqada HLOOKUP

• Lookup_ Value : Qiimaha laga helayo safka kowaad ee miiska.
• shaxda^{(Table array)} _ Isticmaal tixraac Magaca Range ^{(Range Name)}ama^(Range) Range . Qiimaha safka kowaad ee shaxda_ Array^{(Table_ Array)} waxa uu noqon karaa qoraal, tirooyin, ama qiimayaal macquul ah. Haddii Range_ Raadinta run^{(Range_ Lookup)} tahay , qiyamka safka koowaad ee shaxda ^(Table)_Array^(TRUE) waa in loo habeeyaa siday u korto, tusaale ahaan, AZ.  HLOOKUP ma bixin doonto qiimaha saxda ah haddii Range_ Raadinta ay ^{(Range_ Lookup)}been^(FALSE) tahay ; Shaxda^(Table) _Array uma baahna kala saarid.
• Saf _index_num^{(Row ­_index_num)} : Saf_ Index_Num waa in loo baahan yahay. Nambarka safafka ee shaxda_ Array^{(Table_ Array)} kaas oo qiimaha u dhigma ay tahay inuu ka soo noqdo. Haddii safka_Tuska_Num^{(Row_Index_Num)} uu ka yar yahay hal, shaqada HLOOKUP waxay soo celin doontaa # Qiimaha^(Value) !  Kaas^(Which) oo ah qiime khalad ah. Haddii Tusaha_Tumber_Num^{(Row_Index_ Num)} uu ka weyn yahay tirada safafka ee shaxda_Array^{(Table_ Array)} , HLOOKUP waxay soo celin doontaa # REF ! Qiimaha^{(Error Value)} Qaladka
• Range _Lookup : Range_ Raadinta^{(Range_ Lookup)} waa ikhtiyaari. Waa qiime macquul ah oo qeexaya haddii aad rabto in HLOOKUP ay hesho ciyaar sax ah ama ciyaar qiyaas ah.

Shaqada HLOOKUP waa in la isticmaalo marka qiyamka isbarbardhigga ay ku jiraan safafka sare ee miiska xogta, oo aad rabto inaad eegto saf cayiman. Tababarkan, waxaan ku sharixi doonaa sida loo sameeyo shaqada HLOOKUP .

Sida loo isticmaalo shaqada HLOOKUP ee Excel

Casharradan, waxaan rabnaa inaan ku eegno Heerka^(Lookup) Raridda shay^{(Shipping Rate)} kasta oo shaxda ku jira.

Guji^(Click) unugga meesha aad rabto inaad dhigto natiijada shaqada, ka dibna u tag Formulas tab oo dooro Qalabka Raadinta iyo Tixraaca^{(Lookup and Reference Tool)}   ee Kooxda Shaqada iyo maktabadda^{(Function and library Group)} , ee ku yaal liiska hoos-u-dhaca.

Dooro HLOOKUP, oo sanduuqa wada-hadalka doodaha shaqada ayaa soo bixi doona ^{(Arguments )}.^(Function)

Sanduuqa wada hadalka doodaha Function^{(Function Arguments)} , ku qor unugga aad rabto inaad ka beddesho sanduuqa qoraalka Lookup_ Value .

Sanduuqa qoraalka ee Table_ Array, waxaanu ku qornaa ^{(Table_ Array )}B8: D9 ; sababtoo ah kani waa Range of cells aan eegayno.

Marka ay timaado safka index_ tirada^{(Row_ Index_ Num)} , dooro saf. Tusaale ahaan, sawirka kore, waxaad arki doontaa in xogta miiska laga bilaabo safka 2aad.

Raadinta Range^{(Range Lookup)} , ku qor Been^(False) sababtoo ah waxaad rabtaa ciyaar sax ah. Dooro OK _ Waxaad arki doontaa natiijadaada.

Xulashada^(Option) kale waa in aad ku qorto qaacidada = HLOOKUP (qiimaha raadinta, miiska _array, row_ index_num, [range lookup]^{(HLOOKUP (lookup value, table _array, row_ index_num, [range lookup] )} oo geli xogtaada .

Waxaan rajeynayaa in tani ay ku caawineyso.

How to use the HLOOKUP function in Microsoft Excel

HLOOKUP is a Function in Microsoft Excel that looks for values in a Horizontal list. The HLOOKUP function searches for values Horizontally in the top row of a Table or Array, and returns a value from the column of the same Table or Array of value, and returns the value from a row you specify.  The H in LOOKUP stands for horizontal. The difference between the VLOOKUP and HLOOKUP is that the VLOOKUP searches for columns and the HLOOKUP look for rows.

Function Syntax for HLOOKUP

• Lookup_ Value: The value to be found in the first row of the table.
• Table array: The table where the information is looked up. Use a reference to a Range or Range Name. The value in the first row of Table_ Array can be text, numbers, or logical values. If the Range_ Lookup is TRUE, the values of the first row of the Table _Array must be arranged in ascending order, for instance, A-Z.  HLOOKUP will not give the correct value if the Range_ Lookup is FALSE; Table _Array does not need sorting.
• Row ­_index_num: Row_ Index_Num must be required.  The row number in Table_ Array from which the matching value must return. If the Row_Index_Num is less than one, the HLOOKUP function will return the #Value!  Which is an error value.  If the Row_Index_ Num is greater than the number of rows on Table_ Array, HLOOKUP will return the #REF! Error Value.
• Range ­_Lookup: Range_ Lookup is optional. It is a logical value that specifies whether you want HLOOKUP to find an exact match or an approximate match.

The HLOOKUP function should be used when the comparison values are in a row across the top of a table of data, and you want to look at a specified row. In this tutorial, we will explain how to create an HLOOKUP function.

How to use the HLOOKUP function in Excel

In this tutorial, we want to Lookup the Shipping Rate of each item in the table.

Click the cell where you want to place the function’s result, then go to the Formulas tab and select the Lookup and Reference Tool  in the Function and library Group, in the drop-down menu.

Choose HLOOKUP, and a Function Arguments dialog box will appear.

In the Function Arguments dialog box, type the cell you want to change in the Lookup_ Value text box.

In the Table_ Array text box, we type B8:D9; because this is the Range of cells we are looking at.

When it comes to the Row_ Index_ Num, select a row. For instance, in the image above, you will see that the table’s data starts from row 2.

In the Range Lookup, type False because you want an exact match. Select Ok. You will see your result.

The Other Option is to type the formula =HLOOKUP (lookup value, table _array, row_ index_num, [range lookup] and input your data.

Hope this helps.

Related posts

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Hagaaji Soo Celinta Xogta. Sug dhowr ilbiriqsi oo isku day inaad mar kale gooyso ama nuqul ka sameyso qaladka Excel

• Talooyin iyo tabaha Microsoft Excel ee bilowga ah

• Sida loo rakibo oo loo isticmaalo add-ins gudaha Microsoft Word iyo Excel ee iPadka

• Sida Loo Abuuro Oo Loo Badbaadiyo Xaashiyaha Faafinta Excel ee Microsoft Office ee Android

• Sida loo tirtiro qiyamka unugyada laakiin ku ilaali qaacidooyinkaaga, gudaha Microsoft Excel

• Sida loogu daabaco baqshadda gudaha Microsoft Excel

• Sida loogu dabaqo Xaqiijinta Xogta Unugyada Microsoft Excel

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida looga saaro erayga sirta ah ee Excel File

• Sida loo Copy and paste value without formula in Excel

• Sida loo Quful Unugyada Microsoft Excel

• Hagaaji Microsoft Excel furitaanka daaqad banaan

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• 3 siyood oo erayga sirta ah loo ilaaliyo File Excel