01 ngo 01
Excel UMSEBENZI Umsebenzi
QHUBA Usebenziso ngokubanzi
Umsebenzi weMATCH usetyenziselwa ukubuyisela inombolo ebonisa indawo ehambelana nedatha kwoluhlu okanye uluhlu lweetyeli ezikhethiweyo. Isetyenziswe xa indawo yezinto ezikhankanywe kwimiba iyadingeka endaweni yento leyo.
Ulwazi oluchanekileyo lunokuba ngumbhalo okanye idatha yesazisi.
Ngokomzekelo, kumfanekiso ongentla, ifom equkethe umsebenzi we-MATCH
= MATCH (C2, E2: E7,0)
ubuyisela indawo enxulumene neGizmos njengesi-5, kuba kungeniso yesihlanu kwi-F3 ukuya kwi-F8.
Ngokufanayo, ukuba udidi lweC1: C3 luqulethe iinombolo ezinjenge-5, 10, kunye ne-15, ngoko-formula
= IMATCH (15, C1: C3,0)
ubuya kubuya inani le-3, kuba i-15 yinto yokungena yesithathu kwibala.
Ukudibanisa umxholo kunye neminye imisebenzi ye-Excel
Umsebenzi we-MATCH usetyenziswa ngokubambisana neminye imisebenzi yokujonga njengeVLOOKUP okanye i- INDEX kwaye isetyenziswe njengengeniso kwezinye iziphakamiso zomsebenzi , njenge:
- i- col_index_num ingxabano yeVLOOKUP;
- umgca- umxholo we-INDEX umsebenzi.
UMSEBENZI WOMSEBENZI ISintax kunye neArguments
I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, iibakaki, abahluli be-comma kunye neengxabano.
I-syntax yomsebenzi we-MATCH yile:
= MATCH (Lookup_value, Lookup_array, Match_type)
I-Lookup_value - (efunekayo) ixabiso enifuna ukuyifumana kwiluhlu lwedatha. Le ngxabano ingaba inomboro, itekisi, ixabiso elifanelekileyo, okanye iselferensi yeseli .
Lookup_array - (efunekayo) uluhlu lweeseli ezicatshungulwayo.
Match_type - (ukhetho) uxelela i-Excel indlela yokufanisa i-Lookup_value kunye namaxabiso kwiLookup_array. Ixabiso elingagqibekanga le ngxabano yi-1. Iinqununu: -1, 0, okanye 1.
- Ukuba iMat__pepe = 1 okanye ingashiywanga: UMATCH ufumana ixabiso elikhulu kunazo zonke okanye lilingana neLookup_value. Idatha yeLookup_array kufuneka ihlelwe ngokunyuka komyalelo.
- Ukuba iMat__pepe = 0: IMATCH ifumana ixabiso lokuqala elilingana neLookup_value. Idatha yeLookup_array ingahlulwa kunoma yimuphi umyalelo.
- Ukuba iMat__pepe = -1: IMATCH ifumana ixabiso elincinane kunaleyo okanye lilingana neLookup_value. Idata yeLookup_array kufuneka ihlelwe ngokuhlehla.
Umzekelo Ukusebenzisa UMSEBENZI WOMSEBENZI we-Excel
Lo mzekelo uya kusebenzisa umsebenzi weMATCH ukufumana indawo yegama elithi Gizmos kwisahlu yolwazi.
Izinketho zokungena kumsebenzi kunye neengxabano zayo ziquka:
- Ukuthayipha umsebenzi ophelele njenge = MATCH (C2, E2: E7,0) kwiseli yomsebenzi
- Ukufaka umsebenzi kunye neengxabano usebenzisa ibhokisi yencoko yencoko yomsebenzi
Ukusebenzisa ibhokisi leNtsebenzo yebhokisi yokusebenza
Amanyathelo angezantsi iinkcukacha ukuba ungene njani UMSEBENZI weMATCH kunye neengxabano usebenzisa ibhokisi yencoko kumzekelo oboniswe kumfanekiso ongentla.
- Cofa kwiseli D2 - indawo apho iziphumo zomsebenzi ziboniswa khona
- Cofa kwiTrafom ithebhu yemenyu yebhondi
- Khetha uLookup kunye neNkcukacha kwi-Ribbon ukuvula uluhlu lokuhla kwehla
- Cofa kwi- MATCH kuloluhlu ukukhupha ibhokisi yencoko yencoko yomsebenzi
- Kwibhokisi yencoko, nqakraza kumgca weLookup_value
- Cofa kwiseli C2 kwiphepha lokusebenzela ukuze ufake ifowuni yesibini kwibhokisi yencoko
- Cofa kwiLowokup_array kumgca kwibhokisi yencoko
- Gqamisa iiseli E2 ukuya ku-E7 kwiphepha lokusebenzela ukuze ufake ibhola kwibhokisi yencoko
- Cofa kumgca we Match_type kwibhokisi yencoko
- Faka inombolo " 0 " (akukho zicatshulwa) kulo mgca ukufumana umdlalo ochanekileyo kwedatha kwiseli D3
- Cofa u-OK ukugqiba umsebenzi kwaye uvale ibhokisi yencoko
- Inombolo "5" ibonakala kwiseli D3 ekubeni igama elithi Gizmos liyinto yesihlanu ukusuka phezulu kwiluhlu lwempahla
- Xa ucofa kwiseli D3 umsebenzi opheleleyo = IMATCH (C2, E2: E7,0) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela
Ukufumana indawo yezinye izinto zoLuhlu
Esikhundleni sokungena eGizmos njengengxabano yeLookup_value , eli gama lifakwe kwiseli kunye neeseli D2 kwaye ke loo ntetho yesalathisi ingeniswa njengengxabano yomsebenzi.
Le ndlela yenza kube lula ukukhangela izinto ezahlukeneyo ngaphandle kokuba uguqule ifom ye-lookup.
Ukukhangela into ehlukile - njengeGadi -
- Faka igama lenxalenye kwiseli C2
- Cinezela ukhiye wokungena kwikhibhodi
Isiphumo kwi-D2 siya kuhlaziywa ukubonisa indawo kwiluhlu lwegama elitsha.