01 ye 01
Excel MATCH Function
BATSIRA Function Overview
Basa reMATCH rinoshandiswa kudzorera nhamba iyo inoratidza nzvimbo yakakwana yedhesi mune urongwa kana kuti yakasarudzwa masero emasero. Inoshandiswa apo chinzvimbo chechinhu chakataurwa pane imwe nzvimbo chinoda pane nzvimbo yacho pachayo.
Mashoko akajeka anogona kunge ari mavara kana nhamba yedata .
Somuenzaniso, mumufananidzo uri pamusoro, chirevo chine MATCH basa
= MATCH (C2, E2: E7,0)
inodzorera nzvimbo yakakwana yeGizmos se5 , sezvo ichinyorwa chechishanu munharaunda F3 kusvika F8.
Saizvozvowo, kana runhare C1: C3 ine nhamba dzakadai sa 5, 10, uye 15, uye iyo inomira
= MASHOKO (15, C1: C3,0)
vaizodzoka nhamba 3, nokuti 15 ndiyo inopinda muchitatu.
Kubatanidza MATCH nemamwe mabasa eExcel
Basa reMATCH rinowanzoshandiswa pamwe chete nemamwe mabasa ekutevedzera akadai saVLOOKUP kana INDEX uye anoshandiswa sechipo kune zvimwe zvese zvinoshanda, zvakadai se:
- the col_index_num argument for VLOOKUP;
- iyo mutsara- nharo dzeIndEX basa.
ICHI MATCH Basa Rinoitwa Syntax uye Arguments
Mutsara webasa unoreva kurongeka kwebasa racho uye rinosanganisira zita rebasa, mabheji, vatengesi vemavara, uye nharo.
Mutsara weMATCH basa ndewokuti:
= MATCH (Lookup_value, Lookup_array, Match_type)
Lookup_value - (inodikanwa) kukosha kwaunoda kuwana pane zvakakosheswa. Iyi nharo inogona kuva nhamba, zvinyorwa, kukosha kwepamusoro, kana sero reference .
Lookup_array - (inodikanwa) uwandu hwemasero ari kutsvaga.
Match_type - (kusarudza) inoudza Excel kuti ingasangana sei neLookup_value nemitemo muLookup_array. Iko kusakosha kunokosha kweiyi nharo ndeyo 1. Zvisarudzo: -1, 0, kana 1.
- Kana Match_type = 1 kana kuti yakasiyiwa: MATCH inowana kukosha kukuru kudarika kana kuenzana neLookup_value. Dhora reLookup_array rinofanira kuenzaniswa mukukwira.
- Kana Match_type = 0: MATCH inowana kukosha kokutanga yakakodzana chaizvo neLookup_value. Dhora reLookup_array rinogona kugadziriswa chero ripi zvaro.
- Kana Match_type = -1: MATCH inowana kukosha kuduku kudarika kana kuenzana neLookup_value. Dhora reLookup_array rinofanira kuenzanisirwa richidzika.
Muenzaniso Kushandisa MATCH MATCH Function
Uyu muenzaniso unoshandisa basa reMATCH kuwana nzvimbo yezwi rokuti Gizmos mune imwe nhamba yekuverenga.
Zvisarudzo zvekupinda mubasa uye nharo dzayo dzinosanganisira:
- Kunyora basa rakakwana rakafanana = MATCH (C2, E2: E7.0) mumusero webasa rekushanda
- Kupinda basa uye nharo dzinoshandisa bhokisi rebasa rebasa
Kushandisa MATCH Dialog Box Dialog Box
Matanho ari pasi apa tsanangudzo yekuti ungapinda sei MATCH basa uye nharo dzinoshandisa bhokisi rebhokisi nokuda kwemuenzaniso wakaratidzwa mumufananidzo uri pamusoro.
- Dzvanya pane cell D2 - nzvimbo iyo migumisiro yebasa iri kuratidzwa
- Dzvanya paMafomu yebhu yebhoni yebhoni
- Sarudza Kuona uye Kutarisa kubva kubhoni kuti uzarure basa rinoderera pasi
- Dzvanya FUNGA PAMUSORO kuti uratidze bhokisi rebasa rebasa
- Mubhokisi rebhokisi, tora paRookup_value line
- Dzvanya pachitokisi C2 mune pepa rekushanda kuti uise seferensi yesero mubhokisi rebhokisi
- Dzvanya paLowokup_array line mubhokisi rebhokisi
- Simbisai masero E2 kusvika kuE7 mubasa rekushandisa kuti uise mubhokisi mubhokisi rebhokisi
- Dzvanya paMatch_type line mubhokisi rebhokisi
- Pinda nhamba " 0 " (hapana zvinyorwa) pamutsara uyu kuti uwane mutsara chaiwo kune data iri muchitokisi D3
- Dzvanya OK kuti upedze basa uye uvhare bhokisi rebhokisi
- Nhamba ye "5" inowanikwa muchitokisi D3 sezvo izwi rokuti Gizmos ndiro chinhu chechishanu kubva kumusoro mubhuku rekuverenga
- Paunenge uchibvisa pane cell D3 zvakakwana basa = MATCH (C2, E2: E7.0) inowanikwa mubhairi yepamusoro pane pepa rekushanda
Kuwana Nzvimbo Yezvimwe Zvinyorwa Zvinhu
Panzvimbo pokupinda muGizmos sezvinonzi Lookup_value argument, izwi racho rakapinda muchitokisi uye sechitokisi D2 uye ipapo iyo tsanangudzo yekare ndiyo inopindirwa sepikisheni yebasa racho.
Iyi nzira inoita kuti zvive nyore kutsvaga zvinhu zvakasiyana kunze kwekuda kushandura fomu yekutsvaga.
Kutsvaga chimwe chinhu chakasiyana-siyana seGadgets -
- Isa chikamu chechikamu muchitoro C2
- Dhinda pikicha inopinda mubhokisi
Chigumisiro cheD2 chichavandudzwa kuti chiratidze chinzvimbo chiri muzita rezita idzva.