Umsebenzi we-Excel MATCH: Ukuthola indawo yedatha

01 ka 01

Umsebenzi we-Excel MATCH

Ukuthola Isikhundla Esihlobene Sokwaziswa Nge-Function Match. © Ted French

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:

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.

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:

  1. Ukuthayipha umsebenzi ophelele njengo = MATCH (C2, E2: E7,0) esitokisini somsebenzi
  2. 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.

  1. Chofoza kuseli D2 - indawo lapho imiphumela yomsebenzi iboniswa khona
  2. Chofoza kuthebhu yefomula yemenyu ye- ribbon
  3. Khetha Ukubheka kanye neNkhombandlela kusuka kubhebhoni ukuvula uhlu lwehla lokusebenza
  4. Chofoza ku- MATCH ohlwini ukuze ukhulise ibhokisi lengxoxo lomsebenzi
  5. Ebhokisini lengxoxo, chofoza kumugqa we- Lookup_value
  6. Chofoza kuseli C2 kushidi lokusebenzela ukuze ufake ireferensi yeseli ebhokisini lengxoxo
  7. Chofoza kulayini Lookup_array ebhokisini lengxoxo
  8. Gqamisa amaseli e-E2 kuya ku-E7 kushidi lokusebenzela ukufaka ibanga ebhokisini lengxoxo
  9. Chofoza kumugqa we- Match_type ebhokisini lengxoxo
  10. Faka inombolo " 0 " (ayikho izingcaphuno) kulo mkhakha ukuze uthole ukufanelana ngqo nedatha kuseli D3
  11. Chofoza OK ukuqedela umsebenzi bese uvala ibhokisi lengxoxo
  12. Inombolo "5" ivela esitokisini D3 kusukela ngegama elithi Gizmos yinto yesihlanu kusukela phezulu ohlwini lokusungula
  13. 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 -

  1. Faka igama lesigcawu ku-cell C2
  2. Cindezela ukhiye wokungena kwikhibhodi

Umphumela ku-D2 uzobuyekezwa ukuze ubonise isikhundla ohlwini lwamagama amasha.