01 of 03
Tsvaga Mutengo Zvokubhadhara naVLOOKUP
Izvo Basa reVLOOKUP Rinoshanda Sei
Google Spreadsheets 'VLOOKUP basa , iyo inomiririra kuratidzika , inogona kushandiswa kutarisa mashoko chaiwo ari mutafura ye data kana dheseti.
- Mashoko pamusoro pevhangeri yeVLOOKUP anogona kuwanikwa papeji 3
VLOOKUP inowanzodzorera munda umwe we data sezvo yakabuda. Iyo inoita sei izvi ndeyikuti:
- Iwe unopa zita kana tsvakurudzo -key inotaurira VLOOKUP mumutsara wei kana rekodhi yematafura yedeta kuti utsvake data yaunoda
- Iwe unopa nhamba yekorodhe -inozivikanwa sehurukuro - ye data iwe waunotsvaka
- Basa racho rinotarisa kutsvaga_kutsvaga muhombe yekutanga yedhafura ye data
- VLOOKUP anobva atora uye anodzorera ruzivo rwaunotsvaka kubva kune imwe munda wekodha imwechete uchishandisa iyo inotengeswa nhamba yenhamba
Kuwana Matanho Akaenzana neVLOOKUP
Kazhinji, VLOOKUP inoedza kuwana mhando chaiyo ye- search_key inoratidzwa. Kana mutsara chaiwo usingagoni kuwanika, VLOOKUP inogona kuwana mamiriro ekuenzanisa.
- Chimwe chienzanidzo ndicho mutsanana wepedyo wekutsvaga_kukura muhukuru hushoma kana kuti huri pasi pekukosha.
- Pakati pemitambo inowanikwa nekugadzirisa basa racho nderaka-yakagadziriswa ku TRUE.
Kuronga Dhiyabhorosi Kutanga
Kunyange zvazvo zvisingawanzodiwa nguva dzose, zvinowanzova zvakanaka kuti utange kutarisa huwandu hwemashoko ayo VLOOKUP ari kutsvaga mukukwira urongwa achishandisa korona yokutanga yemuchina wekodzero yemhando.
Kana iyo data isati yakarongwa, VLOOKUP inogona kudzorera chikonzero chisina kururama.
VLOOKUP Function Example
Muenzaniso uri mumufananidzo uri pamusoro unoshandisa fomu inotevera inotevera basa reVLOOKUP kuti uwane kuderedzwa kwehuwandu hwezvinhu zvakatengwa.
= VLOOKUP (A2, A5: B8,2, TRUE)
Kunyange zvazvo urongwa huri pamusoro apa hunogona kuiswa muchengeti rekushanda, rimwe sarudzo, sezvinoshandiswa nematanho ari pasi apa, nderokushandisa bhokisi reGoogle Spreadsheets auto-rinokumbira kupinda mufomu.
Kupinda Basa reVLOOKUP
Nhanho dzekupinda mubasa reVLOOKUP rinoratidzwa mumufananidzo pamusoro apa muchikamu B2 nde:
- Dzvanya pachitokisi B2 kuti uite sero rinoshandiswa - iyi ndiyo iyo migumisiro yebasa reVLOOKUP icharatidzwa
- Tora chiyero chakakwana (=) chinotevera zita rekushanda vlookup
- Sezvaunonyora, bhokisi -self- bhokisi rinowanikwa nemazita uye maonero ezvinyorwa zvinotanga netsamba V
- Apo zita rokuti VLOOKUP rinowanikwa mubhokisi, chengetedza zita nezine mouse pointer kuti uise zita rebasa uye uzarure bhatikiti rose muchitsi B2
Kupinda Maitiro Akashanda
- Tsanangudzo yakajeka pamusoro peshoko reVLOOKUP uye nharo dzinogona kuwanikwa pane peji 2
- Sezvakaitwa muExcel, nhamba inowanikwa pakati pemafungiro emabasa ekuita separadziri.
Izvo zvikonzero zvebasa reVLOOKUP zvakapinda mushure mokuzaruka kwebhuka rakasununguka muchitokisi B2.
- Dzvanya pane sero A2 mune pepa rekushanda kuti uite ino seferensi seyiyo mutsva- kutsvaga
- Mushure mokunge sero rinotarisa, shandisai comma ( , ) kuita separadzanisa pakati pemakakatanwa
- Simbisai masero A5 kusvika B8 mune pepa rekushandisa kuti uise izvi zvinyorwa semafungiro ehurukuro yakatarisana - zvinyorwa zvepafura hazvina kuiswa mukati
- Mushure mokunge sero rinotarisa, tora imwe kamera
- Tora a 2 mushure mokunge comma inopinda nhaurirano yechirangariro sezvo kubhadharwa kwemazinga ari mu column 2 yemubvunzo wepakati
- Mushure mokuverenga nhamba 2, nyora imwe kamma
- Simbisai masero B3 uye B4 mubasa rekushandisa kuti uise izvi zvinyorwa sehotera yekutamba
- Tora shoko rokuti Ichokwadi shure kwema-comma seyi- sorted argument
- Dhinda pikicha inopinda mubhobhoyo kuti uise bhivha rekuvhara " ) " mushure mekugadzirisa kwebasa rekushanda uye kupedzisa basa
- Mhinduro 2.5% - kuwedzera kwehuwandu hwehuwandu hwakatengwa - hunofanira kuonekwa muchitokisi B2 chebasa
- Paunenge uchinge uri pa cell B2, basa rakakwana = VLOOKUP (A2, A4: B8, 2, True,) rinowanikwa mubhairi yepamusoro pane pepa rekushanda
Nei VLOOKUP Yakadzoka 2.5% seGumisiro
- Mumuenzaniso, yeWorld column haina mutsara chaiwo wekutsvaga_key value ye 23.
- Sezvo i_kukakavadzana kwakagadzirirwa ku TRUE, VLOOKUP ichawana mutsara wakatarisana nehutsva hwekutsvaga_key .
- Kukosha kwepedyo muhukuru hwakanga huri hudiki kudarika ku_kutsvaga_keykey kwe 23 ndiko 21.
- VLOOKUP, saka, anotarisa chikamu chekutsvaga mumutsara waiva nemakumi maviri nemashanu, uye, semugumisiro, inodzorera kuderedzwa kwema 2.5%.
02 of 03
Google Spreadsheets Syntax uye Arguments VLOOKUP Function
Vhangeri yeVLOOKUP's Syntax uye Arguments
Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .
Mutsara webasa reVLOOKUP ndewokuti:
= VLOOKUP (tsvakurudzo_key, mararamiro, rondedzero, i-inofanirwa)
search_key - (inoda) kukosha kwekutsvaga - yakadai sehuwandu hwakatengeswa mumufananidzo kumusoro
mararamiro - (inoda) nhamba yemakoroni nemitsetse iyo VLOOKUP inofanira kutsvaga
- korona yekutanga mumugero kazhinji ine chekutsvaga_key
nhamba - (inodikanwa) nhamba yekorodhe yenhamba yaunoda inowanikwa
- kuverenga kunotanga ne- search_key column iyo column 1
- kana nheyo inotaridzwa kune nhamba yakakura kudarika nhamba yemakorani akasarudzwa mumakakatanwa akawanda #REF! kukanganisa kunodzoserwa nebasa racho
is_sorted - (optional) inoratidza kuti kana kwete iyo yakarongwa yakakwira ichikwira urongwa uchishandisa korona yekutanga yebhanhire rekutsvaga
- kukosha kweBoolean - TRUE kana FALSE ndiyo chete inofanirwa kukoshesa
- kana yakagadzirirwa ku TRUE kana kusakanganiswa uye kora yekutanga yezera haisi kurongwa mukukwira, chirati chisina kururama chinogona kuitika
- kana asiripo, kukosha kunotarirwa ku TRUE kuburikidza
- kana yakagadzirirwa ku TRUE kana kusakanganiswa uye kunyatsopindirana kwekutsvaga_kutsvaga hakuwanikwi, mutsara wepfupi uri muduku muhukuru kana kukosha inoshandiswa se-search_key.
- kana yakagadzirirwa kuFALSE, VLOOKUP inogamuchira mamiriro chaiwo e-search_key. Kana pane mitemo yakaenzana yakaenzana, kukosha kwekutanga kufanana kunodzorerwa
- kana yakagadzirirwa kuFALSE, uye hapana nhamba inofanirana ye-search_key inowanikwa # N / A kukanganisa kunodzoserwa nebasa
03 of 03
VLOOKUP Error Messages
VLOOKUP Error Messages
Izvo zvinotevera mhosho zvinyorwa zvinosanganiswa neVLOOKUP.
An # N / A ("kukosha haisipo") kukanganisa kunoratidzwa kana:
- Tsva_kutsvaga hakuwanikwi muhombe yekutanga yemakakatanwa akasiyana
- Nharo huru yakasiyana haina kururama. Semuenzaniso, nharo dzinogona kusanganisira mbiru dzisina chinhu kune rumwe rutivi rworuboshwe
- Icho- chinokonzera kukwikwidzana chakaiswa kuFALSE uye mamiriro chaiwo emutsano wekutsvaga_kutsvaga haugone kuwanikwa muhombe yekutanga yezera
- Iko-inopikisana yakagadzirirwa ku TRUE uye yose yehutsika mukorori yekutanga yezera yakakura kudarika search_key
A #REF! ("rondedzera kubva kune rumwe") kukanganisa kunoratidzwa kana:
- Nhamba yehurukuro yakakura kudarika nhamba yemakoroni mumakakatanwa akasiyana