Umsebenzi we-VLOOKUP ku-Excel – Umhlahlandlela Wabaqalayo: I-syntax nezibonelo

Namuhla siqala uchungechunge lwezihloko ezichaza esinye sezici eziwusizo kakhulu ze-Excel − VPR (I-VLOOKUP). Lo msebenzi, ngesikhathi esifanayo, ungomunye wezinto eziyinkimbinkimbi kakhulu futhi ezingaqondakali kancane.

Kulesi sifundo ku VPR Ngizozama ukubeka izisekelo kalula ngangokunokwenzeka ukuze ngenze inqubo yokufunda icace ngangokunokwenzeka kubasebenzisi abangenalwazi. Ngaphezu kwalokho, sizofunda izibonelo ezimbalwa ngamafomula e-Excel azokhombisa izimo ezivame kakhulu zokusetshenziswa komsebenzi VPR.

  • Incazelo evamile kanye ne-syntax
  • Izibonelo ze-VLOOKUP
    • Isetshenziswa kanjani i-VLOOKUP ukusesha kwelinye ishidi le-Excel
    • Sesha kwenye incwadi yokusebenzela nge-VLOOKUP
    • Indlela yokusebenzisa ububanzi obuqanjwe igama noma ithebula kumafomula nge-VLOOKUP
    • Ukusebenzisa i-Wildcards kumafomula e-VLOOKUP
  • Okufana ncamashi noma okulinganisayo kumsebenzi we-VLOOKUP
  • I-VLOOKUP ku-Excel - udinga ukukhumbula lokhu!

Umsebenzi we-VLOOKUP ku-Excel - incazelo evamile kanye ne-syntax

Pho kuyini VPR? Okokuqala, kuwumsebenzi we-Excel. Wenzani? Ibheka inani olicacisayo futhi ibuyisela inani elihambisanayo ukusuka kwenye ikholomu. Uma sikhuluma ngobuchwepheshe, VPR ibheka inani elikukholomu yokuqala yobubanzi obunikeziwe futhi ibuyisela umphumela usuka kwenye ikholomu kumugqa ofanayo.

Kuhlelo lokusebenza oluvame kakhulu, umsebenzi VPR isesha imininingo egciniwe ukuze ithole isihlonzi esikhethekile futhi ikhiphe ulwazi oluthile oluhlobene naso kusizindalwazi.

Uhlamvu lokuqala egameni lomsebenzi VPR (VLOOKUP) kusho Вmpo (Vmpo). Ngayo ungakwazi ukuhlukanisa VPR kusukela I-GPR (HLOOKUP), esesha inani kumugqa ophezulu wobubanzi − Гokuvundlile (Hngokuvundlile).

Umsebenzi VPR itholakala ku-Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, kanye ne-Excel 2000.

I-syntax yomsebenzi we-VLOOKUP

Umsebenzi VPR (I-VLOOKUP) ine-syntax elandelayo:

VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])

ВПР(искомое_значение;таблица;номер_столбца;[интервальный_просмотр])

Njengoba ubona, umsebenzi VPR ku-Microsoft Excel inezinketho ezi-4 (noma izimpikiswano). Ezokuqala ezintathu ziyimpoqo, ezokugcina uyazikhethela.

  • ukubheka (lokup_value) - Inani okufanele ulibheke. Lokhu kungaba inani (inombolo, idethi, umbhalo) noma ireferensi yeseli (equkethe inani lokubheka), noma inani elibuyiswe omunye umsebenzi we-Excel. Isibonelo, le fomula izobheka inani 40:

    =VLOOKUP(40,A2:B15,2)

    =ВПР(40;A2:B15;2)

Uma inani lokubheka lingaphansi kwenani elincane kunawo wonke kukholomu yokuqala yobubanzi obubhekwayo, umsebenzi VPR izobika iphutha #AT (#N/A).

  • itafula_ukuthi (ithebula) – amakholomu amabili noma ngaphezulu edatha. Khumbula, umsebenzi VPR njalo ibheka inani kukholomu yokuqala yobubanzi obunikezwe kumpikiswano itafula_ukuthi (ithebula). Ibanga elibukwayo lingaqukatha idatha ehlukahlukene, njengombhalo, izinsuku, izinombolo, ama-booleans. Umsebenzi awuzweli, okusho ukuthi izinhlamvu ezingosonhlamvukazi nezincane zithathwa njengezifana. Ngakho ifomula yethu izobheka inani 40 kumaseli asuka A2 kuya A15, ngenxa yokuthi A uyikholomu yokuqala yobubanzi A2:B15 obunikezwe kumpikiswano itafula_ukuthi (ithebula):

    =VLOOKUP(40,A2:B15,2)

    =ВПР(40;A2:B15;2)

  • inombolo_yenkomba (inombolo_yekholomu) iyinombolo yekholomu ebangeni elinikeziwe okuzobuyiswa kulo inani elikumugqa otholiwe. Ikholomu ekwesokunxele kakhulu kububanzi obunikeziwe ithi 1, ikholomu yesibili ithi 2, ikholomu yesithathu ithi 3 njalo njalo. Manje usungafunda yonke ifomula:

    =VLOOKUP(40,A2:B15,2)

    =ВПР(40;A2:B15;2)

    Ifomula ibheka inani 40 ebangeni A2:A15 futhi ibuyisela inani elihambisanayo kukholomu B (ngoba B uyikholomu yesibili kububanzi A2:B15).

Uma inani lempikiswano inombolo_yenkomba (inombolo_yekholomu) ingaphansi kuka 1ke VPR izobika iphutha #INANI! (#INANI!). Futhi uma ingaphezu kwenani lamakholomu kububanzi itafula_ukuthi (ithebula), umsebenzi uzobuyisela iphutha #REF! (#XHUMANA!).

  • bheka_ububanzi (range_lookup) - inquma ukuthi yini okufanele uyibheke:
    • ukufana okuqondile, ukungqubuzana kufanele kulingane FALSE (AMAMANGA);
    • ukufanisa, ukungqubuzana kuyalingana IKHODI LEQINISO (TRUE) noma akucaciswanga nhlobo.

    Le parameter ingokuzithandela, kodwa ibaluleke kakhulu. Kamuva kulesi sifundo ku VPR Ngizokukhombisa izibonelo ezithile ezichaza ukuthi ungabhala kanjani amafomula okuthola ukufana okuqondile nokucishe kufane.

Izibonelo ze-VLOOKUP

Ngithemba umsebenzi VPR kucace kancane kuwe. Manje ake sibheke ezinye izimo zokusebenzisa VPR kumafomula anedatha yangempela.

Isetshenziswa kanjani i-VLOOKUP ukusesha kwelinye ishidi le-Excel

Empeleni, amafomula anomsebenzi VPR azivamile ukusetshenziswa ukusesha idatha ekhasini lokusebenza elifanayo. Kaningi kunalokho, uzobe ubheka phezulu futhi ubuyisa amanani ahambelanayo asuka kwelinye ishidi.

Ukuze usebenzise VPR, sesha kwelinye ishidi le-Microsoft Excel, Kufanele ku-agumenti itafula_ukuthi (ithebula) cacisa igama leshidi elinophawu lwesibabazo olulandelwa uhla lwamaseli. Isibonelo, ifomula elandelayo ibonisa ukuthi ububanzi A2:B15 iseshidini elinegama Ishidi2.

=VLOOKUP(40,Sheet2!A2:B15,2)

=ВПР(40;Sheet2!A2:B15;2)

Yebo, igama leshidi akudingeki lifakwe mathupha. Vele uqale ukuthayipha ifomula, futhi uma kukhulunywa ngempikiswano itafula_ukuthi (ithebula), shintshela eshidini olifunayo bese ukhetha ububanzi obufunekayo bamaseli ngegundane.

Ifomula eboniswe kusithombe-skrini esingezansi ibheka umbhalo othi “Umkhiqizo 1” kukholomu A (yikholomu yokuqala yobubanzi A1:B2) ekhasini lokusebenza. amanani.

=VLOOKUP("Product 1",Prices!$A$2:$B$9,2,FALSE)

=ВПР("Product 1";Prices!$A$2:$B$9;2;ЛОЖЬ)

Sicela ukhumbule ukuthi lapho usesha inani lombhalo, kufanele ulifake kuzimpawu zokucaphuna (“”), njengoba kuvamise ukwenziwa kumafomula e-Excel.

Okokuphikisana itafula_ukuthi (ithebula) kuyathandeka ukuthi ngaso sonke isikhathi usebenzise izinkomba eziphelele (nophawu lwe-$). Kulesi simo, uhla losesho luzohlala lungashintshiwe lapho ukopisha ifomula kwamanye amaseli.

Sesha kwenye incwadi yokusebenzela nge-VLOOKUP

Ukuze usebenze VPR esebenza phakathi kwezincwadi zokusebenzela ze-Excel ezimbili, udinga ukucacisa igama lencwadi yokusebenzela kubakaki abayisikwele ngaphambi kwegama leshidi.

Isibonelo, ngezansi kunefomula ebheka inani 40 eshidini Ishidi2 encwadini Izinombolo.xlsx:

=VLOOKUP(40,[Numbers.xlsx]Sheet2!A2:B15,2)

=ВПР(40;[Numbers.xlsx]Sheet2!A2:B15;2)

Nansi indlela elula yokwenza ifomula ku-Excel ngayo VPRexhuma kwenye incwadi yokusebenzela:

  1. Vula zombili izincwadi. Lokhu akudingekile, kodwa kulula ukwakha ifomula ngale ndlela. Awufuni ukuzifaka mathupha igama lebhuku lokusebenza, akunjalo? Ngaphezu kwalokho, izokuvikela ekubhaleni ngephutha.
  2. Qala ukuthayipha umsebenzi VPRfuthi uma kukhulunywa ngengxabano itafula_ukuthi (ithebula), shintshela kwenye incwadi yokusebenzela bese ukhetha uhla lokusesha oludingekayo kuyo.

Isithombe-skrini esingezansi sibonisa ifomula enosesho olusethwe kububanzi encwadini yokusebenzela PriceList.xlsx eshidini amanani.

Umsebenzi VPR izosebenza ngisho noma uvala incwadi yokusebenzela eseshiwe futhi indlela egcwele eya efayeleni lencwadi yokusebenzela ivela kubha yefomula, njengoba kukhonjisiwe ngezansi:

Uma igama lencwadi yokusebenzela noma ishidi liqukethe izikhala, kufanele lifakwe kuma-aphostrophe:

=VLOOKUP(40,'[Numbers.xlsx]Sheet2'!A2:B15,2)

=ВПР(40;'[Numbers.xlsx]Sheet2'!A2:B15;2)

Indlela yokusebenzisa ububanzi obuqanjwe igama noma ithebula kumafomula nge-VLOOKUP

Uma uhlela ukusebenzisa uhla lokusesha olufanayo emisebenzini eminingi VPR, ungakha ububanzi obuqanjwe igama bese ufaka igama labo kufomula njengengxabano itafula_ukuthi (ithebula).

Ukuze udale ububanzi obuqanjwe igama, mane ukhethe amaseli bese ufaka igama elifanele endaweni Igama, kwesokunxele sebha yefomula.

Manje usungakwazi ukubhala phansi ifomula elandelayo yokuthola intengo yomkhiqizo Umkhiqizo we-1:

=VLOOKUP("Product 1",Products,2)

=ВПР("Product 1";Products;2)

Amagama amaningi obubanzi asebenza kuyo yonke incwadi yokusebenzela ye-Excel, ngakho-ke asikho isidingo sokucacisa igama leshidi lempikiswano itafula_ukuthi (ithebula), noma ngabe ifomula nobubanzi bokusesha kumakhasi okusebenzela ahlukene. Uma zisezincwadini zokusebenza ezihlukene, khona-ke ngaphambi kwegama lohlu udinga ukucacisa igama lencwadi yokusebenzela, isibonelo, kanje:

=VLOOKUP("Product 1",PriceList.xlsx!Products,2)

=ВПР("Product 1";PriceList.xlsx!Products;2)

Ngakho-ke ifomula ibonakala icace kakhulu, uyavuma? Futhi, ukusebenzisa ububanzi obuqanjiwe kungenye indlela enhle yezithenjwa eziphelele ngoba ububanzi obuqanjwe igama abushintshi lapho ukopisha ifomula kwamanye amaseli. Lokhu kusho ukuthi ungaqiniseka ukuthi ububanzi bokusesha kufomula buzohlala bulungile.

Uma uguqula uhla lwamaseli lube isipredishithi se-Excel esigcwele usebenzisa umyalo Ithebula (Ithebula) ithebhu Insertion (Faka), lapho-ke ukhetha ububanzi ngegundane, iMicrosoft Excel izongeza ngokuzenzakalelayo amagama ekholomu (noma igama lethebula uma ukhetha lonke ithebula) efomini.

Ifomula eqediwe izobukeka kanjena:

=VLOOKUP("Product 1",Table46[[Product]:[Price]],2)

=ВПР("Product 1";Table46[[Product]:[Price]];2)

Noma mhlawumbe kanje:

=VLOOKUP("Product 1",Table46,2)

=ВПР("Product 1";Table46;2)

Uma usebenzisa ububanzi obuqanjiwe, izixhumanisi zizokhomba kumaseli afanayo kungakhathaliseki ukuthi uwukopisha kuphi umsebenzi VPR ngaphakathi kwebhuku lokusebenza.

Ukusebenzisa i-Wildcards kumafomula e-VLOOKUP

Njengeminye imisebenzi eminingi, VPR Ungasebenzisa izinhlamvu ze-wildcard ezilandelayo:

  • Uphawu lombuzo (?) – luthatha indawo yanoma yimuphi uhlamvu olulodwa.
  • Inkanyezi (*) - ithatha indawo yanoma yikuphi ukulandelana kwezinhlamvu.

Ukusebenzisa ama-Wildcards kokuthi Imisebenzi VPR kungaba usizo ezimweni eziningi, isibonelo:

  • Lapho ungakhumbuli kahle umbhalo okufanele uwuthole.
  • Uma ufuna ukuthola igama elithile eliyingxenye yokuqukethwe kweseli. Yazi lokho VPR icinga ngokuqukethwe kweseli lilonke, njengokungathi inketho inikwe amandla Qondanisa konke okuqukethwe kweseli (Yonke iseli) kusesho olujwayelekile lwe-Excel.
  • Uma iseli liqukethe izikhala ezengeziwe ekuqaleni noma ekupheleni kokuqukethwe. Esimweni esinjalo, ungakwazi ukunyakazisa ubuchopho bakho isikhathi eside, uzama ukuthola ukuthi kungani ifomula ingasebenzi.

Isibonelo sokuqala: Ukufuna umbhalo oqala noma ogcina ngezinhlamvu ezithile

Ake sithi ufuna ukusesha ikhasimende elithile kusizindalwazi esiboniswe ngezansi. Awusikhumbuli isibongo sakhe, kodwa uyazi ukuthi siqala ngokuthi “ack”. Nali ifomula ezokwenza umsebenzi kahle:

=VLOOKUP("ack*",$A$2:$C$11,1,FALSE)

=ВПР("ack*";$A$2:$C$11;1;ЛОЖЬ)

Manje njengoba usuqinisekile ukuthi uthole igama elilungile, ungasebenzisa indlela efanayo ukuze uthole inani elikhokhwe yileli khasimende. Ukuze wenze lokhu, vele uguqule impikiswano yesithathu yomsebenzi VPR enombolweni yekholomu oyifunayo. Esimweni sethu, lena yikholomu C (yesithathu ebangeni):

=VLOOKUP("ack*",$A$2:$C$11,3,FALSE)

=ВПР("ack*";$A$2:$C$11;3;ЛОЖЬ)

Nazi ezinye izibonelo ezinama-wildcards:

~ Thola igama eligcina ngokuthi “umuntu”:

=VLOOKUP("*man",$A$2:$C$11,1,FALSE)

=ВПР("*man";$A$2:$C$11;1;ЛОЖЬ)

~ Thola igama eliqala ngokuthi "isikhangiso" futhi ligcine ngokuthi "indodana":

=VLOOKUP("ad*son",$A$2:$C$11,1,FALSE)

=ВПР("ad*son";$A$2:$C$11;1;ЛОЖЬ)

~ Sithola igama lokuqala ohlwini, elinezinhlamvu ezi-5:

=VLOOKUP("?????",$A$2:$C$11,1,FALSE)

=ВПР("?????";$A$2:$C$11;1;ЛОЖЬ)

Ukuze usebenze VPR ngama-wildcards asebenze kahle, njengengxabano yesine okufanele uyisebenzise njalo FALSE (AMAANGA). Uma ububanzi bokusesha buqukethe inani elingaphezu kwelilodwa elifana namagama okusesha namakhadi asendle, kusho ukuthi inani lokuqala elitholiwe lizobuyiswa.

Isibonelo sesi-2: Hlanganisa ama-wildcards nereferensi yeseli kumafomula e-VLOOKUP

Manje ake sibheke isibonelo esiyinkimbinkimbi sendlela yokusesha usebenzisa umsebenzi VPR ngevelu kuseli. Cabanga ukuthi ikholomu A iwuhlu lokhiye belayisense, futhi ikholomu B iwuhlu lwamagama abanikazi belayisensi. Ngaphezu kwalokho, unengxenye (izinhlamvu ezimbalwa) zohlobo oluthile lokhiye welayisensi kuseli C1, futhi ufuna ukuthola igama lomnikazi.

Lokhu kungenziwa ngokusebenzisa ifomula elandelayo:

=VLOOKUP("*"&C1&"*",$A$2:$B$12,2,FALSE)

=ВПР("*"&C1&"*";$A$2:$B$12;2;FALSE)

Le fomula ibheka inani elisuka kuseli C1 kububanzi obunikeziwe futhi ibuyisela inani elihambisanayo kukholomu B. Qaphela ukuthi kumpikiswano yokuqala, sisebenzisa uhlamvu lwe-ampersand (&) ngaphambi nangemuva kwereferensi yeseli ukuze sixhumanise iyunithi yezinhlamvu yombhalo.

Njengoba ungabona esithombeni esingezansi, umsebenzi VPR ibuyisela okuthi “Jeremy Hill” ngoba ukhiye wakhe welayisensi uqukethe ukulandelana kwezinhlamvu ezivela kuseli C1.

Qaphela ukuthi ingxabano itafula_ukuthi (Ithebula) kusithombe-skrini ngenhla liqukethe igama lethebula (Ithebula7) esikhundleni sokucacisa ububanzi bamaseli. Yilokhu esikwenzile esibonelweni esedlule.

Okufana ncamashi noma okulinganisayo kumsebenzi we-VLOOKUP

Futhi ekugcineni, ake sibhekisise impikiswano yokugcina eshiwo ngomsebenzi VPR - bheka_ububanzi (i-interval_view). Njengoba kushiwo ekuqaleni kwesifundo, le mpikiswano ibaluleke kakhulu. Ungathola imiphumela ehluke ngokuphelele kufomula efanayo nenani layo IKHODI LEQINISO (IQINISO) noma FALSE (AMAANGA).

Okokuqala, ake sithole ukuthi i-Microsoft Excel isho ukuthini ngokufana ncamashi nokulinganiselwa.

  • Uma ingxabano bheka_ububanzi (ububanzi_ukubheka) bulingana ne FALSE (FALSE), ifomula ibheka okufanayo ncamashi, okungukuthi inani elifana ncamashi nelinikezwe kumpikiswano ukubheka (bheka_inani). Uma kukholamu yokuqala yobubanzi takwazi_amalungu afanayo (ithebula) ihlangabezana namanani amabili noma ngaphezulu afana ne-agumenti ukubheka (search_value), bese kukhethwa eyokuqala. Uma kungekho okufanayo okutholakele, umsebenzi uzobika iphutha #AT (#N/A). Isibonelo, ifomula elandelayo izobika iphutha #AT (#N/A) uma lingekho inani kububanzi A2:A15 4:

    =VLOOKUP(4,A2:B15,2,FALSE)

    =ВПР(4;A2:B15;2;ЛОЖЬ)

  • Uma ingxabano bheka_ububanzi (ububanzi_ukubheka) bulingana ne IKHODI LEQINISO (TRUE), ifomula ibheka ukufana okulinganiselwe. Ngokunembayo, okokuqala umsebenzi VPR ibheka okufana ncamashí, futhi uma kungatholakali, ikhetha okucishe kufane. Ukufanisa okulinganiselwe yinani elikhulu elingadluli inani elishiwo ku-agumenti. ukubheka (bheka_inani).

Uma ingxabano bheka_ububanzi (ububanzi_ukubheka) bulingana ne IKHODI LEQINISO (TRUE) noma kungashiwongo, khona-ke amanani akukholomu yokuqala yobubanzi kufanele ahlungwe ngokulandelana okunyukayo, okungukuthi, ukusuka kwelincane kakhulu kuye kwelikhulu. Uma kungenjalo, umsebenzi VPR ingase ibuyisele umphumela oyiphutha.

Ukuze uqonde kangcono ukubaluleka kokukhetha IKHODI LEQINISO (IQINISO) noma FALSE (AMANGA), ake sibheke amanye amafomula ngomsebenzi VPR futhi ubheke imiphumela.

Isibonelo 1: Ukuthola Okufana Nangempela ne-VLOOKUP

Njengoba ukhumbula, ukucinga okufanayo ngqo, impikiswano yesine yomsebenzi VPR kufanele kube nendaba FALSE (AMAANGA).

Ake sibuyele etafuleni kusukela esibonelweni sokuqala futhi sithole ukuthi yisiphi isilwane esingahamba ngesivinini 50 amamayela ngehora. Ngikholwa ukuthi le fomula ngeke ikubangele ubunzima:

=VLOOKUP(50,$A$2:$B$15,2,FALSE)

=ВПР(50;$A$2:$B$15;2;ЛОЖЬ)

Qaphela ukuthi uhla lwethu losesho (ikholomu A) luqukethe amanani amabili 50 – kumaseli A5 и A6. Ifomula ibuyisela inani elisuka kuseli B5. Kungani? Ngoba lapho ufuna okufanayo ngqo, umsebenzi VPR isebenzisa inani lokuqala elitholiwe elifana nalelo liseshwayo.

Isibonelo sesi-2: Ukusebenzisa i-VLOOKUP ukuze uthole ukulinganisa okufanayo

Lapho usebenzisa uhlelo VPR ukucinga okufanayo, okungukuthi lapho ingxabano bheka_ububanzi (ububanzi_ukubheka) bulingana ne IKHODI LEQINISO (IQINISO) noma yeqiwe, into yokuqala okudingeka uyenze ukuhlela ububanzi ngekholomu yokuqala ngokulandelana okunyukayo.

Lokhu kubaluleke kakhulu ngoba umsebenzi VPR ibuyisela inani elikhulu elilandelayo ngemva kwalelo elinikeziwe, bese ukusesha kuyama. Uma ukunganaki ukuhlunga okulungile, uzogcina unemiphumela exakile noma umyalezo wephutha. #AT (#N/A).

Manje ungasebenzisa eyodwa yamafomula alandelayo:

=VLOOKUP(69,$A$2:$B$15,2,TRUE) or =VLOOKUP(69,$A$2:$B$15,2)

=ВПР(69;$A$2:$B$15;2;ИСТИНА) or =ВПР(69;$A$2:$B$15;2)

Njengoba ubona, ngifuna ukuthola ukuthi yisiphi isilwane esinejubane eliseduze kakhulu 69 amamayela ngehora. Futhi nawu umphumela umsebenzi wabuyela kimi VPR:

Njengoba ubona, ifomula ibuyise umphumela I-Antelope (I-Antelope), ijubane layo 61 amamayela ngehora, nakuba uhlu luhlanganisa I-Cheetah (Cheetah) ogijima ngesivinini 70 amamayela ngehora, kanti u-70 usondele ku-69 kunama-61, akunjalo? Kungani lokhu kwenzeka? Ngoba umsebenzi VPR lapho usesha cishe okufanayo, ibuyisela inani elikhulu elingelikhulu kunalelo eliseshwayo.

Ngethemba ukuthi lezi zibonelo zinikeza ukukhanya okuthile ekusebenzeni nomsebenzi VPR ku-Excel, futhi awusambheki njengomuntu wangaphandle. Manje akulimazi ukuphinda kafushane amaphuzu ayisihluthulelo okwaziswa esikufundile ukuze sikulungise kangcono enkumbulweni.

I-VLOOKUP ku-Excel - udinga ukukhumbula lokhu!

  1. Umsebenzi VPR I-Excel ayikwazi ukubheka kwesokunxele. Ihlala ibheka inani elikukholamu kwesokunxele impela yobubanzi obunikezwe ukuphikisana itafula_ukuthi (ithebula).
  2. Kuyasebenza VPR wonke amanani awanawo amacala, okungukuthi izinhlamvu ezincane nezinkulu ziyalingana.
  3. Uma inani olifunayo lingaphansi kwenani eliphansi kukholomu yokuqala yobubanzi obubhekwayo, umsebenzi VPR izobika iphutha #AT (#N/A).
  4. Uma ingxabano yesi-3 inombolo_yenkomba (inombolo_yekholomu) ingaphansi kuka 1umsebenzi VPR izobika iphutha #INANI! (#INANI!). Uma likhulu kunenombolo yamakholomu kububanzi itafula_ukuthi (ithebula), umsebenzi uzobika iphutha #REF! (#XHUMANA!).
  5. Sebenzisa amareferensi amaseli aphelele ekungqubuzaneni itafula_ukuthi (ithebula) ukuze kugcinwe uhla lokusesha olulungile lapho kukopishwa ifomula. Zama ukusebenzisa ububanzi obuqanjiwe noma amathebula ku-Excel njengenye indlela.
  6. Uma wenza ukusesha okulinganiselwe kokufanisa, khumbula ukuthi ikholomu yokuqala kububanzi obufunayo kufanele ihlungwe ngohlelo olukhuphukayo.
  7. Ekugcineni, khumbula ukubaluleka kwempikiswano yesine. Sebenzisa amanani IKHODI LEQINISO (IQINISO) noma FALSE (AMAMANGA) ngamabomu futhi uzosusa amakhanda amaningi.

Ezindabeni ezilandelayo zesifundo sethu somsebenzi VPR ku-Excel, sizofunda izibonelo ezithuthuke kakhulu, njengokwenza izibalo ezihlukahlukene sisebenzisa VPR, ikhipha amanani kumakholomu amaningi, nokuningi. Ngiyabonga ngokufunda lesi sifundo futhi ngithemba ukukubona futhi ngesonto elizayo!

shiya impendulo