Shaqada MATCH ee Microsoft Excel waa Raadinta iyo Tixraaca shaqada^{(Lookup and Reference function)} , ujeeddadeeduna waa in la raadiyo shay gaar ah oo kala duwan oo unug ah ka dibna soo celisa booska qaraabada ah ee shayga inta u dhaxaysa. Qaaciddada MATCH waa MATCH(lookup_ value, lookup_array[match_type]).

Ereyga isku dhafka ah ee Function Match^{(Match Function)} waa:

• Lookup_ value: Qiimaha aad rabto inaad ku mid noqoto lookup_array. Waa loo baahan yahay.
• Lookup_array: Tirada unugyada la baadhayo Waa loo baahan yahay.
• Match_type: Qeexayaa sida lookup_value la mid yahay lookup_array. Waa ikhtiyaari.

Gudaha Microsoft Excel , waxaa jira saddex nooc oo match_type 1,0,-1. The "1" match_type wuxuu helaa qiimaha ugu weyn ee ka yar ama la mid ah qiimaha fiirinta. The" 0 " match_type waxa uu helaa qiimaha ugu horeeya ee la siman lookup_value. The "-1 "match_type wuxuu helaa qiimaha ugu yar ee ka weyn ama la mid ah qiimaha raadinta

Sida loo isticmaalo shaqada MATCH gudaha Excel

Si aad u isticmaasho shaqada MATCH gudaha Excel , raac hababka hoose:

1. Fur Excel
2. Samee miis ama isticmaal miiska jira
3. Geli^(Enter) formula = MATCH (lookup_ value, lookup_array[match_type]) gudaha unugga aad rabto in natiijadu noqoto
4. Riix Gelida
5. Daawo natiijada

Daahfurka Excel .

Samee miis ama isticmaal miiska jira.

Geli qaacidada   =MATCH (54, B2:B7,1 ) unugga aad rabto in natiijadu noqoto.

54 waa Lookup_value aad rabto in aad ku wanagto qaabka raadinta.

B2:B7 waa Lookup_array iyo tirada unugyada la baaray.

1 waa Match_type , ujeeddadeeduna waa in la qeexo sida loo eegayo_qiimaha u dhigma lookup_array.

Riix^(Press) furaha Gelida^(Enter) si aad natiijada u hesho

Waxaa jira laba hab oo kale oo loo isticmaalo shaqada MATCH gudaha Excel .

Habka koowaad waa inaad gujiso badhanka fx ee bidix ee sare ee xaashida shaqada ee Excel .

Sanduuqa wada hadalka Gelida ayaa soo bixi doona^{(Insert Function)} .

Gudaha sanduuqa wada hadalka ee qaybta, Dooro Qaybta^{(Select a Category)} , ka dooro Raadinta iyo Tixraaca^{(Lookup and Reference)} sanduuqa liiska.

Qaybta Dooro Function^{(Select a Function)} , ka dooro shaqada  MATCH  liiska.

Kadib dhagsii OK .

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa furmi doona.

Gudaha LookUp_^{(LookUp_ value)} sanduuqa qiimaha, ku qor 54 .

Sanduuqa LookUp_ array , ku qor B2:B7 .

In sanduuqa Match_type , nooca 1 .

Kadib riix OK si aad u aragto natiijada.

Habka labaad waa in la gujiyo tabka Formulas oo aad gujiso ^{(Formulas )}Lookup and Reference button in the Function Library group.

Liiska hoos-u-dhaca, dooro shaqada MATCH .

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa soo bixi doona.

Raac tillaabooyinka habka koowaad ee  Doodaha Shaqada^{(Function Arguments)} .

Waxaan rajeyneynaa in casharkan uu kaa caawinayo inaad fahamto sida loo isticmaalo shaqada MATCH ee Microsoft Excel ; haddii aad wax su'aalo ah ka qabto casharrada, noogu soo sheeg faallooyinka.

Akhri soo socda^{(Read next)} : Sida loo isticmaalo shaqada DEC2Bin ee Microsoft Excel^{(use the DEC2Bin function in Microsoft Excel)} si loogu beddelo jajab tobanle oo loo beddelo binary.

How to use the MATCH function Microsoft Excel

The MATCH function in Microsoft Excel is a Lookup and Reference function, and its purpose is to search for specific items in a range of cell and then returns the relative position of that item in the range. The formula for the MATCH is MATCH(lookup_ value, lookup_array[match_type]).

The syntax for the Match Function is:

• Lookup_ value: The value you want to match in the lookup_array. It is required.
• Lookup_array: The range of cells being searched. It is required.
• Match_type: Specifies how lookup_value matches with lookup_array. It is optional.

In Microsoft Excel, there are three types of match_type 1,0,-1. The “1” match_type finds the largest value that is less than or equal to the look_up value. The” 0 “ match_type finds the first value that is exactly equal to the lookup_value. The “-1 “match_type finds the smallest value that is greater than or equal to the lookup value

How to use the MATCH function in Excel

To use the MATCH function in Excel, follow the methods below:

1. Launch Excel
2. Create a table or use an existing table
3. Enter the formula = MATCH(lookup_ value, lookup_array[match_type]) into the cell you want the result to be
4. Press Enter
5. See the result.

Launch Excel.

Create a table or use an existing table.

Enter the formula  =MATCH (54, B2:B7,1 ) into the cell you want the result to be.

54 is the Lookup_value you want to match with the lookup array.

B2:B7 is the Lookup_array and the range of cells being searched.

1 is the Match_type, and its purpose is to specify how lookup_value matches with lookup_array.

Press the Enter key to get the result

There are two other methods to use the MATCH function in Excel.

Method one is to click the fx button on the top left of the Excel worksheet.

An Insert Function dialog box will appear.

Inside the dialog box in the section, Select a Category, select Lookup and Reference from the list box.

In the section Select a Function, choose the  MATCH  function from the list.

Then click OK.

A Function Arguments dialog box will open.

In the LookUp_ value box, type 54.

In the LookUp_ array box, type B2:B7.

In the Match_type box, type 1.

Then click OK to see the result.

Method Two is to click the Formulas tab and click the Lookup and Reference button in the Function Library group.

In the drop-down menu, select the MATCH function.

A Function Arguments dialog box will appear.

Follow the steps in method one for  Function Arguments.

We hope this tutorial helps you understand how to use the MATCH function in Microsoft Excel; if you have questions about the tutorial, let us know in the comments.

Read next: How to use the DEC2Bin function in Microsoft Excel to convert a decimal number to binary.

Related posts

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• 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 looga saaro erayga sirta ah ee Excel File

• Hagaaji qaladka Excel stdole32.tlb gudaha Windows 10

• Sida loo abuuro Gantt Charts gudaha Microsoft Excel

• Dib u eegis buug - Microsoft Excel 2010 Talaabo Talaabo ah

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

• Farqiga u dhexeeya Microsoft Excel Online iyo Excel ee Desktop

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo kiciyo oo loogu shubo wax-ku-darka Solver ee Microsoft Excel haddii aanu shaqaynayn

• 40 ka ugu wanaagsan ee Keyboard-ka Microsoft Excel

• Talooyin iyo tabaha Microsoft Excel ee bilowga ah

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

• Google Sheets vs Microsoft Excel - Waa maxay faraqa u dhexeeya?

• Hagaaji Microsoft Excel furitaanka daaqad banaan

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

• Sida foormulada loogu qariyo xaashiyaha Microsoft Excel