Excel Nzira mbiri dzekushandisa kushandisa VLOOKUP Chikamu 1

Nokubatanidza basa reVLOOKUP reEcelcel pamwe neMATCH basa , tinogona kuita izvo zvinozivikanwa se -nzira mbiri kana maviri-dimensional yekukumbira fomu inokubvumira kuti uone nyore nyore mazita maviri emashoko mu database kana tafura ye data.

Nzira mbiri yekuona yakakosha inobatsira kana iwe uchida kuwana kana kuenzanisa migumisiro yemamiriro ezvinhu akasiyana-siyana.

Mumuenzaniso unoratidzwa mumufananidzo wepamusoro, fomu yekutsvaga inoita kuti zvive nyore kutora zviyero zvekutengesa kwekiki dzakasiyana mumwedzi yakasiyana nekungoshandura zita rekoki uye mwedzi mumakamuri akakodzera.

01 of 06

Tsvaga Dhiyabhorosi paChipatanho Chiratidzo cheRow uye Column

Iyi dzidzo inoputsika kuita zvikamu zviviri. Kutevera matanho akanyorwa munhengo imwe neimwe inosika nzira mbiri yekuona yakaratidzwa mumufananidzo uri pamusoro.

Dzidzo inosanganisira kusimba basa reMATCH mukati meVLOOKUP.

Kunyora basa kunosanganisira kupinda muchipiri basa seimwe yenharo dzekutanga.

Muchidzidzo ichi, basa reMATCH richapinda sehurukuro yenhamba yenhamba yeVLOOKUP.

Tutorial Contents

• Kupinda Tutorial Data
• Kugadzira Zita Rakataridzirwa Dheta Dheta
• Kutanga Basa reVLOOKUP
• Kupinda Kukosha Kwekuteerera
• Kupinda muTereta Ar Arument
• Kutanga Nested MATCH Function
• Kuwedzera Dhiyabhorosi Rwendo rweMATCH Function
• Kuwedzera Mhando yeMatch uye Kuzadza Basa reMATCH
• Kuzadzisa basa reVLOOKUP
• Kuwedzera Mitsva yekutsvaga Kuedza Iyo Yakagadzirirwa Fomu
• Kupikira Dhiviri Dimensional Lookup Formu ne Fill Handle

02 of 06

Kupinda Tutorial Data

Nhanho yekutanga mune zvidzidzo ndeyekuisa deta muExpcel worksheet .

Mukutevera kutevera matanho ari mudzidzisi pinda data inoratidzwa mumufananidzo pamusoro pemasero anotevera.

• Ita huwandu hwemashoko makuru mumasero D1 kusvika kuF1
• Pinda muganhu wechipiri mumasero D4 kusvika kuG8

Mitsara 2 ne3 yasara isina chinhu kuitira kuti agone kutsvaga nzira yekutsvakurudza uye iyo yekufambisa yakagadzirwa panguva ino.

Dzidzo haisanganisi kuumbwa kunoonekwa mumufananidzo, asi izvi hazvingabatsiri maitiro ekutevedza kwekushandisa.

Mashoko pamusoro pekugadzirisa mafungiro akafanana neaya aonekwa pamusoro apa anowanikwa mune iyi Basic Excel Kuburitsa Tutori .

Tutorial Steps

1. Pinda data sezvinoonekwa mumufananidzo uri pamusoro apa mumasero D1 kusvika kuG8

03 of 06

Kugadzira Zita Rakataridzirwa Dheta Dheta

A zita rakarongeka ndiyo nzira iri nyore yekureva ruzivo rwemashoko mune fomu. Panzvimbo pokunyora mune zvinyorwa zvinyorwa zve data, unogona kungonyora zita remutsetse.

Chinhu chechipiri chekubatsira kushandiswa zita rakarongwa ndechokuti masero ezvitokisi zvezera iri haamboshanduki kunyange kana fomu yacho ikakumbirwa kune mamwe masero mupepa rekushanda.

Tutorial Steps

1. Simbisai masero D5 kuG8 mubasa rekushandisa kuti musarudze
2. Dzvanya paZita reBhokisi riri pamusoro pe column A
3. Tora "tafura" (hapana zvinyorwa) muZita reBhokisi
4. Dhinda iri ENTER kiyi pane keyboard
5. Masero D5 kusvika kuG8 iye zvino ane zita rezita re "tafura". Tichashandisa zita reVLOOKUP tafura array argument gare gare muchidzidzo

04 of 06

Kuvhura bhokisi reDVD reVLOOKUP

Kunyange zvazvo zvichikwanisika kungongoronga purogiramu yedu yekutsvaga muchengeti mune pepa rekushanda, vanhu vazhinji vanoona zvakaoma kuchengetedza syntax yakananga-kunyanya kwemafomu akaoma seyayo yatinoshandisa mune iyi tadzidzo.

Imwe nzira, munyaya iyi, ndeyokushandisa VLOOKUP dialog box . Munenge mese mabasa eExcel ane bhokisi rekubhokisi rinokubvumira kupinda mune imwe nharo dzemabasa pane imwe mutsara.

Tutorial Steps

1. Dzvanya pachitsiko F2 chebasa rekushanda - nzvimbo iyo migumisiro yeiyo miviri yechidimbu yekutsvaga iyo icharatidzwa
2. Dzvanya paMafomu tab yebhoni
3. Dzvanya pakusarudza kweLookup & Referenha mubhubhoni kuti uzarure basa redu rezasi
4. Dzvanya paVLOOKUP mune urongwa kuti uwedzere basa rebhokisi rebhokisi

05 of 06

Kupinda Kukosha Kwekuteerera

Kazhinji, kukosha kwekutsvaga kunoenderana nemunda we data munhare yekutanga yedhafura ye data.

Muenzaniso wedu, kukosha kwekuona kunoreva rudzi rwekoki tinoda kuwana ruzivo pamusoro.

Mvumo yemvumo yedheta yekukosha kwekutsvaga ndeyi:

• text data
• chinhu chinokosha (TRUE kana FALSE chete)
• nhamba
• sero rinotaura nezvekukosha mune pepa rekushanda

Mumuenzaniso uyu tichapinda muchitsauko chesekeri kune kuti zita rekuki richave riripi - cell D2.

Tutorial Steps

1. Dzvanya pamutsetse wekuteerera wevheji mubhokisi rebhokisi
2. Dzvanya pachitokisi D2 kuti uwedzere kurefera kwekeroyi kumutsara wekutsvaga- vhesi . Iyi ndiyo sero yatinonyora zita rekio pamusoro pekuri kutsvaga ruzivo

06 of 06

Kupinda muTereta Ar Arument

Itafura tafura ndiro tafura ye data iyo fomu yekutsvaga inotsvaga kuwana ruzivo rwatinoda.

Itafura yepafura inofanira kunge ine zvinyorwa zviviri zvemashoko .

• iyo kori yekutanga inosanganisira ikozvino kukoshesa nharo yepamusoro (yekutanga danho mumudzidzi)
• chechipiri, uye mamwe mahwendefa ezvimwe, achatsvakurudzwa nefomu rekutsvaga kuti awane ruzivo rwandinotaura.

Itafura yemhando yakakosha inofanirwa kuiswa sevheji rine zvinyorwa zveseti zvetafura ye data kana sezita remhando .

Nokuda kwemuenzaniso uyu, tichashandisa zita rezita rakagadzirwa muchikamu chechitatu chekudzidzisa.

Tutorial Steps

1. Dzvanya patafura- ruvara rutsva mubhokisi rebhokisi
2. Tora "tafura" (hapana zvinyorwa) kuti uise zita rezita remhaka iyi
3. Siya basa reVLOOKUP dialog box rinovhura chikamu chinotevera chekudzidzisa

Rambai muchikamu 2 >>