Ntchito ya VLOOKUP mu Excel - Maupangiri Oyambira: Syntax ndi Zitsanzo

Zamkatimu

Ntchito ya VLOOKUP mu Excel - kufotokozera mwachidule ndi mawu
- Syntax ya ntchito ya VLOOKUP
Zitsanzo za VLOOKUP
Zofanana ndendende kapena pafupifupi mu ntchito ya VLOOKUP
- Chitsanzo 1: Kupeza Zofanana Zenizeni ndi VLOOKUP
- Chitsanzo 2: Kugwiritsa Ntchito VLOOKUP Kupeza Machesi Ofanana
VLOOKUP mu Excel - muyenera kukumbukira izi!

Lero tikuyamba nkhani zingapo zofotokoza chimodzi mwazinthu zothandiza kwambiri za Excel − VPR (VLOOKUP). Ntchitoyi, nthawi yomweyo, ndi imodzi mwazovuta kwambiri komanso zosamvetsetseka.

Mu phunziro ili pa VPR Ndiyesera kuyika zoyambira mophweka momwe ndingathere kuti njira yophunzirira ikhale yomveka bwino kwa ogwiritsa ntchito osadziwa. Kuphatikiza apo, tiphunzira zitsanzo zingapo ndi ma fomula a Excel omwe angawonetse zochitika zomwe zimagwiritsidwa ntchito kwambiri pa ntchitoyi VPR.

Ntchito ya VLOOKUP mu Excel - kufotokozera mwachidule ndi mawu

Ndiye ndi chiyani VPR? Chabwino, choyamba, ndi ntchito ya Excel. Kodi iye amachita chiyani? Imayang'ana mtengo womwe mwafotokoza ndikubwezeretsanso mtengo womwewo kuchokera pagawo lina. Mwaukadaulo, VPR imayang'ana mtengo wagawo loyamba la mzere womwe waperekedwa ndikubweza zotsatira za mzere wina mumzere womwewo.

Muzogwiritsidwa ntchito kwambiri, ntchitoyo VPR amafufuza munkhokwe kuti apeze chizindikiritso chapadera chomwe chapatsidwa ndikuchotsa zina zokhudzana nacho kuchokera munkhokwe.

Chilembo choyamba mu dzina la ntchito VPR (VLOOKUP) amatanthauza Вofukula (Vofukula). Ndi izo mukhoza kusiyanitsa VPR kuchokera GPR (HLOOKUP), yomwe imafufuza mtengo mumzere wapamwamba wamitundu − Гchopingasa (Hchopingasa).

ntchito VPR ikupezeka mu Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, ndi Excel 2000.

Syntax ya ntchito ya VLOOKUP

ntchito VPR (VLOOKUP) ili ndi mawu awa:

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

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

Monga mukuonera, ntchito VPR mu Microsoft Excel ili ndi zosankha 4 (kapena zotsutsana). Zitatu zoyamba ndizovomerezeka, zomaliza ndizosankha.

kumachika (lookup_value) - Mtengo woti muyang'ane. Izi zitha kukhala mtengo (nambala, deti, mawu) kapena cholembera cha cell (chokhala ndi mtengo wowonera), kapena mtengo wobwezeredwa ndi ntchito ina ya Excel. Mwachitsanzo, fomula iyi idzayang'ana mtengo wake 40:
=VLOOKUP(40,A2:B15,2)
=ВПР(40;A2:B15;2)

Ngati mtengo wakuyang'ana ndi wocheperako kuposa mtengo wocheperako mugawo loyamba lazigawo zomwe zikuyang'aniridwa, ntchitoyo VPR adzanena cholakwika #AT (#N / A).

tebulo_tayira (tebulo) - magawo awiri kapena angapo a data. Kumbukirani, ntchito VPR nthawi zonse amayang'ana mtengo mugawo loyamba la mzere woperekedwa mkangano tebulo_tayira (tebulo). Mtundu wowoneka ukhoza kukhala ndi data zosiyanasiyana, monga zolemba, masiku, manambala, ma booleans. Ntchitoyi imakhala yosakhudzidwa, kutanthauza kuti zilembo zazikulu ndi zazing'ono zimatengedwa mofanana. Chifukwa chake fomula yathu imayang'ana mtengo wake 40 m'maselo kuchokera A2 ku A15, chifukwa A ndiye gawo loyamba la mulingo wa A2:B15 woperekedwa pakutsutsa tebulo_tayira (tebulo):
=VLOOKUP(40,A2:B15,2)
=ВПР(40;A2:B15;2)

nambala_index_nambala (column_number) ndi nambala yazagawo mumgawo womwe waperekedwa pomwe mtengo womwe wapezeka ubwezeredwa. Mzati yakumanzere kwambiri pamagawo operekedwawo ndi 1, ndime yachiwiri ndi 2, ndime yachitatu ndi 3 ndi zina zotero. Tsopano mutha kuwerenga chilinganizo chonse:
=VLOOKUP(40,A2:B15,2)
=ВПР(40;A2:B15;2)
Fomula yofufuza mtengo 40 mu osiyanasiyana A2:A15 ndi kubweza mtengo wofananawo kuchokera pagawo B (chifukwa B ndiye gawo lachiwiri mumtundu A2:B15).

Ngati mtengo wa mkangano nambala_index_nambala (gawo_nambala) zochepa kuposa 1ndiye VPR adzanena cholakwika #VALUE! (#VALUE!). Ndipo ngati ili yochulukirapo kuposa kuchuluka kwa zipilala mumtunduwo tebulo_tayira (tebulo), ntchitoyi ibweretsa cholakwika #REF! (#LINK!).

range_kuyang'ana (range_lookup) - imasankha zomwe muyenera kuyang'ana:
- kufanana kwenikweni, mkangano uyenera kukhala wofanana ZONYENGA (ZABODZA);
- pafupifupi machesi, mkangano wofanana KODI YOONA (ZOONA) kapena sizinatchulidwe konse.
Izi parameter ndizosankha, koma zofunika kwambiri. Pambuyo pake mu phunziro ili pa VPR Ndikuwonetsani zitsanzo zofotokozera momwe mungalembe mafomu opezera mafananidwe enieni komanso ofananira.

Zitsanzo za VLOOKUP

Ndikuyembekeza ntchito VPR kumveka bwino pang'ono kwa inu. Tsopano tiyeni tiwone zochitika zina VPR m'mafomu okhala ndi data yeniyeni.

Momwe mungagwiritsire ntchito VLOOKUP kuti mufufuze patsamba lina la Excel

M'malo mwake, mafomu omwe ali ndi ntchito VPR sagwiritsidwa ntchito kawirikawiri kufufuza deta papepala lomwelo. Nthawi zambiri, mudzakhala mukuyang'ana mmwamba ndikupezanso zofananira kuchokera patsamba lina.

Kuti ntchito VPR, fufuzani mu pepala lina la Microsoft Excel, Muyenera kukangana tebulo_tayira (tebulo) tchulani dzina lachitsamba lokhala ndi chizindikiritso chotsatiridwa ndi magulu angapo. Mwachitsanzo, chilinganizo zotsatirazi zikusonyeza kuti osiyanasiyana A2: B15 ili pa pepala lotchedwa Sheet2.

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

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

Inde, dzina la pepala siliyenera kulembedwa pamanja. Ingoyambani kulemba chilinganizo, ndipo zikafika pa mkangano tebulo_tayira (tebulo), sinthani patsamba lomwe mukufuna ndikusankha ma cell omwe mukufuna ndi mbewa.

Njira yomwe yasonyezedwa pachithunzi pansipa imayang'ana mawu akuti "Katundu 1" mugawo A (ndi gawo loyamba la gulu A1:B2) patsamba logwirira ntchito. mitengo.

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

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

Chonde kumbukirani kuti posaka mawu amtengo wapatali, muyenera kuyika m'ma quotation marks (""), monga momwe zimachitikira mu Excel formulas.

Kwa mkangano tebulo_tayira (tebulo) ndikofunikira kugwiritsa ntchito nthawi zonse zolozera (ndi $ sign). Pamenepa, kusaka kudzakhala kosasinthika pokopera fomula kumaselo ena.

Sakani mubuku lina lantchito ndi VLOOKUP

Kugwira ntchito VPR atagwira ntchito pakati pa mabuku awiri a Excel, muyenera kutchula dzina labukhu lantchito m'mabulaketi apakati pamaso pa dzina la pepala.

Mwachitsanzo, pansipa pali chilinganizo chomwe chimayang'ana mtengo wake 40 pa pepala Sheet2 mbuku Nambala.xlsx:

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

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

Nayi njira yosavuta yopangira fomula mu Excel ndi VPRzomwe zikugwirizana ndi bukhu lina la ntchito:

Tsegulani mabuku onse awiri. Izi sizofunikira, koma ndizosavuta kupanga chilinganizo motere. Simukufuna kuyika pamanja dzina la bukhu lantchito, sichoncho? Kuonjezera apo, zidzakutetezani ku typos mwangozi.
Yambani kulemba ntchito VPRndipo zikafika pakukangana tebulo_tayira (tebulo), sinthani ku bukhu lina ndikusankha kusaka komwe kumafunikira.

Chithunzi chomwe chili m'munsimu chikuwonetsa fomula yosaka yomwe yakhazikitsidwa kumitundu yosiyanasiyana mubukhu lantchito PriceList.xlsx pa pepala mitengo.

ntchito VPR idzagwira ntchito ngakhale mutatseka bukhu lantchito lomwe lafufuzidwa ndipo njira yonse yopita ku fayilo ya bukhu lantchito ikuwonekera mu bar ya formula, monga momwe zilili pansipa:

Ngati dzina la bukhulo kapena pepala lili ndi mipata, ndiye kuti liyenera kutsekedwa mu apostrophes:

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

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

Momwe mungagwiritsire ntchito masanjidwe otchulidwa kapena tebulo muma formula ndi VLOOKUP

Ngati mukufuna kugwiritsa ntchito kusaka komweko muzochita zingapo VPR, mutha kupanga mtundu womwe watchulidwa ndikuyika dzina lake munjira ngati mkangano tebulo_tayira (tebulo).

Kuti mupange mtundu wotchulidwa, ingosankhani ma cell ndikuyika dzina loyenera m'mundamo dzina loyamba, kumanzere kwa kapamwamba kapamwamba.

Tsopano mutha kulemba chilinganizo chotsatirachi chopezera mtengo wa chinthu Zamalonda 1:

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

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

Mayina ambiri amitundu yosiyanasiyana amagwira ntchito ku buku lonse la Excel, kotero palibe chifukwa chofotokozera dzina latsamba la mkangano tebulo_tayira (tebulo), ngakhale chilinganizo ndi kusaka zili pamapepala osiyanasiyana. Ngati ali m'mabuku osiyanasiyana ogwirira ntchito, ndiye kuti musanayambe kutchula dzina la bukuli, muyenera kutchula dzina la bukulo, mwachitsanzo, monga chonchi:

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

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

Kotero ndondomekoyi ikuwoneka bwino kwambiri, mukuvomereza? Komanso, kugwiritsa ntchito masanjidwe otchulidwa ndi njira yabwino yosinthira maumboni enieni chifukwa mtundu womwe watchulidwa susintha mukakopera fomula kumaselo ena. Izi zikutanthauza kuti mutha kukhala otsimikiza kuti kusaka kwa fomula kumakhala kolondola nthawi zonse.

Ngati mutembenuza ma cell angapo kukhala spreadsheet yodzaza ndi Excel pogwiritsa ntchito lamulo Table (Table) tabu Kuika (Lowetsani), ndiye mukasankha mitundu ndi mbewa, Microsoft Excel imangowonjezera mayina amzawo (kapena dzina la tebulo ngati mwasankha tebulo lonse) ku fomula.

Fomu yomalizidwa idzawoneka motere:

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

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

Kapenanso monga chonchi:

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

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

Mukamagwiritsa ntchito magawo otchulidwa, maulalo amaloza ku maselo omwewo mosasamala kanthu komwe mungakopere ntchitoyi VPR m'buku la ntchito.

Kugwiritsa ntchito Wildcards mu VLOOKUP Formulas

Mofanana ndi ntchito zina zambiri, VPR Mutha kugwiritsa ntchito zilembo zakutchire zotsatirazi:

Funso (?) - limalowa m'malo mwa munthu mmodzi.
Nyenyezi (*) - imalowa m'malo mwa mndandanda uliwonse wa zilembo.

Kugwiritsira ntchito Wildcards mu Ntchito VPR Zitha kukhala zothandiza nthawi zambiri, mwachitsanzo:

Pamene simukumbukira ndendende lemba muyenera kupeza.
Pamene mukufuna kupeza mawu amene ali mbali ya zili mu selo. Dziwani zimenezo VPR amafufuza ndi zomwe zili mu selo lonse, ngati kuti njirayo yayatsidwa Fananizani zonse zama cell (Selo lonse) mukusaka kokhazikika kwa Excel.
Pamene selo ili ndi mipata yowonjezera kumayambiriro kapena kumapeto kwa zomwe zili. Zikatero, mutha kugwedeza ubongo wanu kwa nthawi yayitali, kuyesa kudziwa chifukwa chake fomula silikugwira ntchito.

Chitsanzo 1: Kuyang'ana mawu omwe amayamba kapena kutha ndi zilembo zina

Tiyerekeze kuti mukufuna kusaka kasitomala wina wake munkhokwe yomwe ili pansipa. Simukumbukira dzina lake lomaliza, koma mukudziwa kuti limayamba ndi "ack". Nayi fomula yomwe ingagwire ntchito bwino:

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

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

Tsopano popeza mwatsimikiza kuti mwapeza dzina lolondola, mutha kugwiritsa ntchito njira yomweyi kuti mupeze ndalama zomwe kasitomalayu walipira. Kuti muchite izi, ingosinthani mkangano wachitatu wa ntchitoyi VPR ku nambala yomwe mukufuna. Kwa ife, iyi ndi gawo C (lachitatu mumtundu):

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

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

Nazi zitsanzo zina zokhala ndi wildcards:

~ Pezani dzina lomaliza ndi "munthu":

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

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

~ Pezani dzina lomwe limayamba ndi "ad" ndipo limatha ndi "mwana":

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

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

~ Timapeza dzina loyamba pamndandanda, wokhala ndi zilembo 5:

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

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

Kugwira ntchito VPR ndi wildcards anagwira ntchito molondola, monga mtsutso wachinayi muyenera kugwiritsa ntchito nthawi zonse ZONYENGA (ZABODZA). Ngati masanjidwewo ali ndi mtengo wopitilira umodzi womwe ukufanana ndi mawu osakira ndi wildcards, ndiye kuti mtengo woyamba womwe wapezeka udzabwezedwa.

Chitsanzo 2: Phatikizani makadi akungongole ndi maumboni a cell mu ma formula a VLOOKUP

Tsopano tiyeni tiwone chitsanzo chovuta kwambiri cha momwe tingafufuzire pogwiritsa ntchito ntchitoyi VPR pa mtengo mu selo. Tangoganizani kuti gawo A ndi mndandanda wa makiyi alayisensi, ndipo gawo B ndi mndandanda wa mayina omwe ali ndi chilolezo. Kuphatikiza apo, muli ndi gawo (zilembo zingapo) zamtundu wina wa kiyi ya layisensi mu selo C1, ndipo mukufuna kupeza dzina la mwiniwake.

Izi zitha kuchitika pogwiritsa ntchito formula iyi:

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

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

Fomulayi imayang'ana mtengo kuchokera ku selo C1 mumndandanda womwe waperekedwa ndikubwezeretsanso mtengo wofananira kuchokera pagawo B. Onani kuti mkangano woyamba, timagwiritsa ntchito zilembo za ampersand (&) isanayambe komanso ikatha kulumikiza chingwe chalemba.

Monga mukuwonera pachithunzichi pansipa, ntchitoyo VPR amabweretsa "Jeremy Hill" chifukwa kiyi yake ya laisensi imakhala ndi mndandanda wa zilembo za cell C1.

Onani kuti mkangano tebulo_tayira (tebulo) pa chithunzi pamwambapa chili ndi dzina la tebulo (Table7) m'malo mofotokoza mitundu ingapo ya ma cell. Izi ndi zomwe tachita mu chitsanzo chapitachi.

Zofanana ndendende kapena pafupifupi mu ntchito ya VLOOKUP

Ndipo potsiriza, tiyeni tione mwatsatanetsatane mtsutso womaliza womwe watchulidwa pa ntchitoyi VPR - range_kuyang'ana (interval_view). Monga tanenera kumayambiriro kwa phunzirolo, mkangano umenewu ndi wofunika kwambiri. Mutha kupeza zotsatira zosiyana kwathunthu munjira yomweyo ndi mtengo wake KODI YOONA (ZOONA) kapena ZONYENGA (ZABODZA).

Choyamba, tiyeni tipeze zomwe Microsoft Excel ikutanthauza ndi machesi enieni komanso pafupifupi.

Ngati mkangano range_kuyang'ana (range_lookup) ndi ofanana ndi ZONYENGA (FALSE), fomula imayang'ana zofananira ndendende, mwachitsanzo mtengo womwewo womwe waperekedwa mumtsutso kumachika (kuyang'ana_mtengo). Ngati mu gawo loyamba la tkuthekera_kosiyanasiyana (tebulo) amakumana ndi zikhalidwe ziwiri kapena zingapo zomwe zimagwirizana ndi mkanganowo kumachika (search_value), ndiye woyamba adzasankhidwa. Ngati palibe zofananira zomwe zapezeka, ntchitoyi iwonetsa cholakwika #AT (#N / A). Mwachitsanzo, njira yotsatirayi ifotokoza zolakwika #AT (#N/A) ngati palibe mtengo mumtundu A2:A15 4:
=VLOOKUP(4,A2:B15,2,FALSE)
=ВПР(4;A2:B15;2;ЛОЖЬ)
Ngati mkangano range_kuyang'ana (range_lookup) ndi ofanana ndi KODI YOONA (ZOONA), fomulayi imayang'ana pafupifupi kufanana. Ndendende, choyamba ntchito VPR amayang'ana zofanana ndendende, ndipo ngati palibe, sankhani pafupifupi. Kuyerekeza kufananitsa ndi mtengo waukulu kwambiri womwe sudutsa mtengo womwe wafotokozedwa mumtsutsowo. kumachika (kuyang'ana_mtengo).

Ngati mkangano range_kuyang'ana (range_lookup) ndi ofanana ndi KODI YOONA (CHOONADI) kapena sichinatchulidwe, ndiye kuti zikhalidwe zomwe zili mugawo loyamba lazigawo ziyenera kusanjidwa mokwera, ndiye kuti, kuyambira zazing'ono mpaka zazikulu. Apo ayi, ntchito VPR ikhoza kubweretsa zotsatira zolakwika.

Kuti mumvetse bwino kufunika kwa kusankha KODI YOONA (CHOONADI) kapena ZONYENGA (ZABODZA), tiyeni tiwone mafomu enanso ndi ntchitoyi VPR ndipo yang'anani zotsatira zake.

Chitsanzo 1: Kupeza Zofanana Zenizeni ndi VLOOKUP

Monga mukukumbukira, kufufuza machesi enieni, mkangano wachinayi wa ntchitoyi VPR ziyenera kukhala zofunika ZONYENGA (ZABODZA).

Tiyeni tibwerere ku tebulo kuchokera ku chitsanzo choyambirira ndikupeza kuti ndi nyama iti yomwe imatha kuyenda pa liwiro 50 mailosi pa ola. Ndikukhulupirira kuti fomulayi sidzakubweretserani zovuta zilizonse:

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

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

Dziwani kuti masanjidwe athu (gawo A) ali ndi zinthu ziwiri 50 - m'maselo A5 и A6. Fomula imabweza mtengo kuchokera ku selo B5. Chifukwa chiyani? Chifukwa pamene mukuyang'ana machesi enieni, ntchitoyo VPR amagwiritsa ntchito mtengo woyamba womwe wapezeka womwe ukufanana ndi womwe ukufufuzidwa.

Chitsanzo 2: Kugwiritsa Ntchito VLOOKUP Kupeza Machesi Ofanana

Mukamagwiritsa ntchito VPR kufunafuna pafupifupi machesi, mwachitsanzo pamene mkangano range_kuyang'ana (range_lookup) ndi ofanana ndi KODI YOONA (ZOONA) kapena zasiyidwa, chinthu choyamba chomwe muyenera kuchita ndikusankha mtunduwo ndi gawo loyamba mu dongosolo lokwera.

Izi ndi zofunika kwambiri chifukwa ntchito VPR imabweretsanso mtengo waukulu wotsatira pambuyo pa yomwe yaperekedwa, ndiyeno kusaka kuyima. Ngati munyalanyaza kusanja koyenera, mudzakhala ndi zotsatira zachilendo kwambiri kapena uthenga wolakwika. #AT (#N / A).

Tsopano mutha kugwiritsa ntchito imodzi mwa njira zotsatirazi:

=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)

Monga mukuonera, ndikufuna kudziwa kuti ndi nyama iti yomwe ili ndi liwiro loyandikira kwambiri 69 mailosi pa ola. Ndipo izi ndi zotsatira zake ntchito inabwerera kwa ine VPR:

Monga mukuwonera, fomula idabweza zotsatira Antelope (Antelope), yemwe liwiro lake 61 mailosi pa ola, ngakhale mndandanda umaphatikizansopo Cheetah (Cheetah) yemwe amathamanga kwambiri 70 mailosi pa ola, ndipo 70 ali pafupi ndi 69 kuposa 61, sichoncho? N’chifukwa chiyani zimenezi zikuchitika? Chifukwa ntchito VPR pofufuza zofananira, zimabweretsa mtengo waukulu kwambiri womwe siukulu kuposa womwe ukufufuzidwa.

Ndikukhulupirira kuti zitsanzo izi zikuwunikira zina pakugwira ntchito ndi ntchitoyi VPR mu Excel, ndipo simumuyang'ananso ngati mlendo. Tsopano sizikupweteka kubwereza mwachidule mfundo zazikulu za nkhani zomwe taphunzira kuti tikonze bwino pamtima.

VLOOKUP mu Excel - muyenera kukumbukira izi!

ntchito VPR Excel siyingayang'ane kumanzere. Nthawi zonse imayang'ana mtengo womwe uli kumanzere kwenikweni kwa mzere woperekedwa ndi mkangano tebulo_tayira (tebulo).
Kugwira ntchito VPR Makhalidwe onse ndi osakhudzidwa, mwachitsanzo, zilembo zazing'ono ndi zazikulu ndizofanana.
Ngati mtengo womwe mukuyang'ana ndi wocheperako kuposa mtengo wocheperako mugawo loyamba lazigawo zomwe zikuyang'aniridwa, ntchitoyo VPR adzanena cholakwika #AT (#N / A).
Ngati mkangano wachitatu nambala_index_nambala (gawo_nambala) zochepa kuposa 1ntchito VPR adzanena cholakwika #VALUE! (#VALUE!). Ngati ndi yayikulu kuposa kuchuluka kwa zipilala mumtunduwo tebulo_tayira (tebulo), ntchitoyi ifotokoza zolakwika #REF! (#LINK!).
Gwiritsirani ntchito maumboni amtheradi a cell pakukangana tebulo_tayira (tebulo) kuti kusaka koyenera kusungidwe pokopera fomula. Yesani kugwiritsa ntchito masanjidwe otchulidwa kapena matebulo mu Excel ngati njira ina.
Pofufuza machesi, kumbukirani kuti gawo loyamba mumndandanda womwe mukufuna liyenera kusanjidwa mongokwera.
Pomaliza, kumbukirani kufunika kwa mkangano wachinayi. Gwiritsani ntchito mfundo zofunika KODI YOONA (CHOONADI) kapena ZONYENGA (ZABODZA) mwadala ndipo mudzachotsa mutu wambiri.

M'nkhani zotsatirazi za phunziro lathu la ntchito VPR mu Excel, tiphunzira zitsanzo zapamwamba kwambiri, monga kuwerengera mosiyanasiyana pogwiritsa ntchito VPR, kuchotsa zikhalidwe kuchokera kumagulu angapo, ndi zina zambiri. Zikomo powerenga phunziroli ndipo ndikuyembekeza kukuwonaninso sabata yamawa!