01 ka 01
Umsebenzi we-Excel MATCH
QHUBA Uhlolojikelele Lokusebenza
Umsebenzi we-MATCH usetshenziselwa ukubuyisela inombolo ebonisa isikhundla esiphathelene nedatha kuhlu noma ibanga elikhethiwe lamaseli. Isetshenziswe lapho indawo yento ecacisiwe ebangeni ifanele esikhundleni sezinto ngokwazo.
Ulwazi olucacisiwe lungaba umbhalo noma idatha yocingo.
Isibonelo, esithombeni ngenhla, ifomula equkethe umsebenzi we-MATCH
= MATCH (C2, E2: E7,0)
ubuyisela indawo ehambisanayo yeGizmos njengo-5, njengoba kungena kwesihlanu ebangeni F3 kuya ku-F8.
Ngokufanayo, uma uhla lwe C1: C3 liqukethe izinombolo ezinjenge-5, 10, no-15, khona-ke ifomula
= MATCH (15, C1: C3,0)
ubuyele inombolo engu-3, ngoba ngu-15 okungena kwesithathu ebangeni.
Ukuhlanganisa i-MATCH neminye imisebenzi ye-Excel
Umsebenzi we-MATCH uvame ukusetshenziselwa ngokuhlanganyela neminye imisebenzi yokubheka njengeVLOOKUP noma i- INDEX futhi isetshenziselwa ukufaka izingxabano zomunye umsebenzi, njenge:
- inkinga ye- col_index_num ye-VLOOKUP;
- umugqa_ukuxabana komsebenzi we-INDEX.
Umsebenzi we-MATCH i-Syntax ne-Arguments
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, ukwahlukanisa kwama-comma, nokuphikisana.
I-syntax yomsebenzi we-MATCH yilezi:
= MATCH (Lookup_value, Lookup_array, Match_type)
I-Lookup_value - (edingekayo) inani ofuna ukuyithola ohlwini lwedatha. Le mpikiswano ingaba inombolo, umbhalo, inani elungile, noma ireferensi yeseli .
I-Lookup_array - (edingekayo) ububanzi bamaseli abuseshwayo.
I-Match_type - (okukhethwa kukho) itjela i-Excel ukuthi ifana kanjani ne-Lookup_value ngamanani ku-Lookup_array. Inani elizenzakalelayo lale mpikiswano yilezi 1. Izinketho: -1, 0, noma 1.
- Uma i-Match_type = 1 noma ishiyiwe: MATCH ithola inani elikhulu kunazo zonke elingaphansi noma elingana ne-Lookup_value. Idatha ye-Lookup_array kufanele ihlungwe ngokunyuka kwe-oda.
- Uma Match_type = 0: MATCH ithola inani lokuqala elilingana ncamashi ne-Lookup_value. Idatha ye-Lookup_array ingahle ihlelwe kunoma iyiphi i-oda.
- Uma i-Match_type = -1: MATCH ithola inani elincane kunazo zonke noma lilingana ne-Lookup_value. Idatha ye-Lookup_array kufanele ihlungwe ngokuhlehlisa.
Isibonelo Ukusebenzisa i-MATCH Function ye-Excel
Lesi sibonelo sizosebenzisa umsebenzi we-MATCH ukuthola indawo yegama elithi Gizmos kuhlu lwama-inventory.
Izinketho zokufaka umsebenzi kanye neziphakamiso zalo zifaka:
- Ukuthayipha umsebenzi ophelele njengo = MATCH (C2, E2: E7,0) esitokisini somsebenzi
- Ukufaka umsebenzi nokuphikisana usebenzisa ibhokisi lengxoxo lomsebenzi
Ukusebenzisa ibhokisi le-MATCH Dialog Box
Izinyathelo ezingezansi imininingwane yokufaka umsebenzi we-MATCH nezimpikiswano usebenzisa ibhokisi lengxoxo yesibonelo esiboniswe esithombeni ngenhla.
- Chofoza kuseli D2 - indawo lapho imiphumela yomsebenzi iboniswa khona
- Chofoza kuthebhu yefomula yemenyu ye- ribbon
- Khetha Ukubheka kanye neNkhombandlela kusuka kubhebhoni ukuvula uhlu lwehla lokusebenza
- Chofoza ku- MATCH ohlwini ukuze ukhulise ibhokisi lengxoxo lomsebenzi
- Ebhokisini lengxoxo, chofoza kumugqa we- Lookup_value
- Chofoza kuseli C2 kushidi lokusebenzela ukuze ufake ireferensi yeseli ebhokisini lengxoxo
- Chofoza kulayini Lookup_array ebhokisini lengxoxo
- Gqamisa amaseli e-E2 kuya ku-E7 kushidi lokusebenzela ukufaka ibanga ebhokisini lengxoxo
- Chofoza kumugqa we- Match_type ebhokisini lengxoxo
- Faka inombolo " 0 " (ayikho izingcaphuno) kulo mkhakha ukuze uthole ukufanelana ngqo nedatha kuseli D3
- Chofoza OK ukuqedela umsebenzi bese uvala ibhokisi lengxoxo
- Inombolo "5" ivela esitokisini D3 kusukela ngegama elithi Gizmos yinto yesihlanu kusukela phezulu ohlwini lokusungula
- Uma uchofoza ku-cell D3 umsebenzi ophelele = MATCH (C2, E2: E7,0) ivela kubha yefomula ngaphezulu kwephepha lokusebenzela
Ukuthola isikhundla sezinye izinto zohlu
Esikhundleni sokungena eGizmos njengokungqubuzana kwe- Lookup_value , leli gama lingena esitokisini naseseli D2 bese kuthi leyo ngqangi yeseli ingenwe njengengxabano yomsebenzi.
Le ndlela yenza kube lula ukucinga izinto ezahlukene ngaphandle kokushintsha ifomula yokubheka.
Ukufuna into ehlukile - njengeziGadi -
- Faka igama lesigcawu ku-cell C2
- Cindezela ukhiye wokungena kwikhibhodi
Umphumela ku-D2 uzobuyekezwa ukuze ubonise isikhundla ohlwini lwamagama amasha.