Ukusebenza etafuleni elijwayelekile kubandakanya ukudonsela amanani kwamanye amatafula kuwo. Uma kunamatafula amaningi, ukuhanjiswa ngesandla kuzothatha inani elikhulu lesikhathi, futhi uma idatha ivuselelwa njalo, lokhu kuzoba ngabasebenzi bakwaSisyphus. Ngenhlanhla, kukhona umsebenzi we-VLOOKUP enikeza amandla wokulanda ngokuzenzakalelayo idatha. Ake sibheke izibonelo ezithile zokuthi lo msebenzi usebenza kanjani.
Incazelo yomsebenzi we-VLOOKUP
Igama lomsebenzi we-VLOOKUP limele "umsebenzi wokubuka mpo." EsiNgisini, igama lakhe lizwakala - VLOOKUP. Lo msebenzi usesha idatha kwikholamu kwesobunxele lebanga elifundiwe, bese ubuyisela inani eliphumelelayo kuseli elicacisiwe. Kalula nje, i-VLOOKUP ikuvumela ukuthi uhlele kabusha amanani kusuka esitokisini kwelinye ithebula ukuya kwelinye itafula. Thola ukuthi ungawusebenzisa kanjani umsebenzi we-VLOOKUP ku-Excel.
ISIBONELELO SE-VLOOKUP
Ake sibheke ukuthi umsebenzi we-VLOOKUP usebenza kanjani kwisibonelo esithile.
Sinamatafula amabili. Owokuqala wayo itafula lokuthenga lapho kubekwa khona amagama emikhiqizo yokudla. Kwikholamu elandelayo ngemuva kwegama inani lesamba lezimpahla ofuna ukuzithenga. Intengo iyalandela. Futhi kwikholamu lokugcina - inani lentengo lokuthenga legama elithile lomkhiqizo, elibalwa ifomula yokuphindaphindeka kwenani ngentengo esivele idonswe esitokisini. Kepha nje kufanele siqinise intengo sisebenzisa umsebenzi we-VLOOKUP kusuka etafuleni elingumakhelwane, okuluhlu lwamanani.
- Chofoza kuseli ephezulu (C3) kukholamu "Intengo" etafuleni lokuqala. Bese uchofoza isithonjana "Faka umsebenzi"okutholakala ngaphambi komugqa wamafomula.
- Ewindini elivulekile le-wizard yokusebenza, khetha isigaba Izinkomba kanye nokufika. Ngemuva kwalokho, kusukela kusethi esetshenzisiwe yemisebenzi, khetha "VPR". Chofoza inkinobho "Kulungile".
- Ngemuva kwalokho, kuvuleka iwindi lapho udinga ukufaka khona izingxabano zomsebenzi. Chofoza inkinobho etholakala ngakwesokunene senkambu yokufaka idatha ukuqala ukukhetha impikiswano yenani olifunayo.
- Njengoba sinenani elifunayo leseli C3, lokhu "Izambane", bese ukhetha inani elihambelanayo. Sibuyela ewindini lokuphikisana lomsebenzi.
- Ngendlela efanayo, chofoza isithonjana ngakwesokudla kwenkambu yokungena yedatha ukukhetha itafula kusuka lapho amanani azodonswa khona.
- Khetha yonke indawo ethebula lesibili lapho amanani azoseshwa khona, ngaphandle kwenhloko. Siphinda sibuyele ewindini lokuphikisana lomsebenzi.
- Ukuze wenze amanani akhethiwe kusuka ku-ngokuphelele "Ithebula", bese ucindezela inkinobho yokusebenza F4. Ngemuva kwalokho, kufakwa izibonakaliso zamadola kusixhumanisi bese siphenduka sibe ngokuphelele.
- Kwikholamu elandelayo Inombolo Yekholomu sidinga ukucacisa inani lekholomu lapho sizokhipha khona amanani. Le kholamu itholakala endaweni engenhla yetafula. Njengoba itafula liqukethe amakholomu amabili, kanti ikholomu enamanani ingeyesibili, sibeka inombolo "2".
- Kwikholamu yokugcina Ukubuka kwesikhashana sidinga ukucacisa inani "0" (FALSE) noma "1" (IQINISO). Esimweni sokuqala, kuzoboniswa kuphela umdlalo oqondile, kuthi owesibili - ukufana okusondele kakhulu. Njengoba igama lomkhiqizo liyidatha yombhalo, azikwazi ukuba cishe, ngokungafani nedatha yamanani, ngakho-ke sidinga ukusetha inani "0". Okulandelayo, chofoza inkinobho "Kulungile".
Njengoba ubona, intengo yamazambane idonswa etafuleni kusuka ohlwini lwamanani. Ukuze singenzi inqubo eyinkimbinkimbi enjalo namanye amagama okuhweba, simane sime ekhoneni elingezansi kwesokudla kweseli eligcwele ukuze kuqhamuke isiphambano. Dweba lesi siphambano phansi kwetafula.
Ngakho-ke, sidonse yonke imininingwane edingekayo ukusuka etafuleni elithile ukuya kwelinye sisebenzisa umsebenzi we-VLOOKUP.
Njengoba ukwazi ukubona, umsebenzi we-VLOOKUP akuyona inkimbinkimbi njengoba kubonakala ekuqaleni. Ukuqonda ukusetshenziswa kwayo akunzima kakhulu, kepha ukulazi leli thuluzi kuzokusindisa ithoni yesikhathi lapho usebenza namatafula.
