01 na 01
Ayyukan Excel MATCH
MATCH Function Overview
Ana amfani da aikin MATCH don dawo da lambar da ta nuna matsayin matsayi na bayanai a cikin jerin ko zaɓuɓɓukan zaɓi na zaɓuɓɓuka. An yi amfani dashi lokacin da ake buƙatar matsayi na kayyadaddun abu a cikin kewayon maimakon abu na kansa.
Bayanan da aka ƙayyade zai iya zama ko rubutu ko bayanai .
Alal misali, a cikin hoton da ke sama, hanyar da take dauke da aikin MATCH
= MATCH (C2, E2: E7.0)
ya koma wurin Gizmos a matsayin dangi 5, tun da shi ne shigarwa na biyar a cikin kewayon F3 zuwa F8.
Haka kuma, idan kewayon C1: C3 ya ƙunshi lambobi kamar 5, 10, da 15, to, dabarar
= MATCH (15, C1: C3,0)
zai dawo lamba 3, saboda 15 shine shigarwa na uku a cikin kewayon.
Haɗa MATCH tare da sauran Ayyukan Excel
Ana amfani da aikin MATCH tare da wasu ayyukan binciken kamar VLOOKUP ko INDEX kuma an yi amfani dasu azaman shigarwa don wasu tambayoyin aikin , kamar:
- amsar col_index_num ga VLOOKUP;
- Shawarar row_num ga aikin INDEX.
Harkokin Sanya MATCH da Magana
Haɗin aikin aiki yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, rabuɗɗun takaddama, da muhawara.
Maganganun aikin MATCH shine:
= MATCH (Lookup_value, Lookup_array, Match_type)
Lookup_value - (da ake buƙatar) darajar da kake so ka samu a cikin jerin bayanai. Wannan jayayya na iya zama lamba, rubutu, ma'ana mai mahimmanci, ko rikodin tantancewa .
Lookup_array - (da ake bukata) kewayon kwayoyin da ake nema.
Match_type - (na zaɓi) ya gaya wa Excel yadda za a daidaita da Lookup_value tare da dabi'u a Lookup_array. Ƙimar tsohuwar wannan hujja shine 1. Zaɓuɓɓuka: -1, 0, ko 1.
- Idan Match_type = 1 ko kuma an cire shi: MATCH ta sami mafi girma da ƙimar da ta kasa da ko daidai da Lookup_value. Dole ne a yi la'akari da bayanan Lookup_array cikin tsari mai girma.
- Idan Match_type = 0: MATCH ya sami darajar farko da daidai daidai da Lookup_value. Ana iya rarraba bayanai na Lookup_array cikin kowane umurni.
- Idan Match_type = -1: MATCH ya sami mafi girman ƙimar da ya fi ko kuma daidai da Lookup_value. Dole ne a yi la'akari da bayanan Lookup_array cikin tsari mai saukowa.
Misali Yin amfani da Harkokin MATCHI na Excel
Wannan misali zai yi amfani da aikin MATCH don neman matsayi na kalmar Gizmos a lissafin kaya.
Zaɓuɓɓukan don shigar da aikin da ƙididdigar sun hada da:
- Rubuta cikakken aikin kamar = MATCH (C2, E2: E7.0) a cikin sashin layi
- Shigar da aiki da muhawara ta amfani da akwatin maganganun aikin
Yin amfani da MATCH Function Dialog Box
Matakai da ke ƙasa dalla-dalla yadda za a shigar da aikin MATCH da muhawara ta amfani da akwatin maganganun misali wanda aka nuna a cikin hoto a sama.
- Danna kan tantanin halitta D2 - wurin da aka nuna sakamakon aikin
- Danna maɓallin Formulas na shafin rubutun
- Zabi Binciken da Magana daga ribbon don bude jerin jerin ayyuka
- Danna kan MATCH a jerin don kawo akwatin maganganu na aikin
- A cikin akwatin maganganu, danna kan layin Lookup_value
- Danna maɓallin C2 a cikin takardun aiki don shigar da tantanin halitta a cikin akwatin maganganu
- Danna kan layin Lookup_array a cikin akwatin maganganu
- Fassara sel E2 zuwa E7 a cikin takardar aiki don shigar da kewayon cikin akwatin maganganun
- Danna maɓallin Match_type cikin akwatin maganganu
- Shigar da lambar " 0 " (no quotes) a kan wannan layi don nemo daidai daidai da bayanai a cikin cell D3
- Danna Ya yi don kammala aikin kuma rufe akwatin maganganu
- Lambar "5" ta bayyana a cell D3 tun lokacin Gizmos shine abu na biyar daga saman a lissafin kaya
- Lokacin da ka danna kan tantanin halitta D3 cikakken aikin = MATCH (C2, E2: E7.0) ya bayyana a cikin maɓallin tsari a sama da takardun aiki
Gano Matsayi na Wasu Abubuwan Lissafin
Maimakon shigar da Gizmos a matsayin shawara na Lookup_value , an shigar da kalmar a cikin tantanin halitta da tantanin halitta D2 sannan kuma an shigar da wannan tantanin halitta a matsayin hujja don aikin.
Wannan tsarin ya sa ya sauƙi don bincika abubuwa daban-daban ba tare da canza fasalin binciken ba.
Don bincika wani abu daban - irin su Gadgets -
- Shigar da sunan ɓangaren cikin cell C2
- Latsa maɓallin shigarwa a kan keyboard
Sakamakon D2 zai sabunta don yin la'akari da matsayi a cikin jerin sunayen sabon.