Computers, Software
Excel Excel - chii ichocho? Dzidza kuti basa reVLOOKUP rinoshanda sei muExcel
VPR Excel inoshanda mumutambo unoenderana, unosiyaniswa nekunaka kwayo uye nyore. Inoshandiswa zvakasiyana-siyana, inoshandiswa munzvimbo dzakasiyana zvakasiyana-siyana: kubva pakudzidzira kusvika kunezvezve. Chirevo chikuru chebasa ndechekutsvaga mitezo mune imwe kana matafura akawanda. Saka unogona kuwana zviri nyore ruzivo rwaunoda, kupedza nguva shoma.
General information
Excel VLOOKUP basa - chii ichocho? Inonziwo VLOOKUP muchirungu cheChirungu. Ichi ndicho chimwe chezvinhu zvakajairika zvemashoko uye zvinyorwa. Nyanzvi dzinoumba chikamu cheBBR ADVICE dzakaratidza hutano hwakaoma hwakaenzana ne3 kana 7.
Kana munhu akashandisa maitiro uye zvinyorwa, zvichava nyore kunzwisisa zviito zveVPR. Muzvinyorwa zvinyorwa zvakasiyana, iwe unogona kuita mashoko omuzasi pane imwe sero. Inoiswa semuenzaniso kana, pane zvinopesana, inoratidzirwa semuenzaniso. Mune basa reVLP, sero iri mufananidzo weA1, D9, K8 nezvimwewo zvinowanzoratidzwa.
Dzimwe nguva kubatana kunopiwa nenzira yakasiyana (R1C1). Mune rimwe shoko, pane chinyorwa uye mutsara, pamativi ose ezvo ruzivo rwaunoda kumushandisi. Purogiramu inowana chiratidzo chaicho chekuti inofanira kutarisa iyi data.
Shandisa maparameter nemuenzaniso
Iko Excel VLOOKUP basa inotanga kusimbisa nhamba yemutsara, inoteverwa nekholomu inonzi. Pakati painofanira kutarisa chimwe chinhu chakadai:
= VRP (A1, Database_Data, 2, FALSE)
- A1. Iyi inofanirwa kuongororwa nesero. Inogona kujekesa chero kukosha, zvichienderana nemugumisiro waunoda kuwana.
- Database_data. Zita renzvimbo yeruzivo kuti iongorwe. Iyo pfungwa haisi yakazara seyo yapfuura. Inogona kungoshandiswa chete pamiganhu yekutanga kana ma column.
- 2. Iyi ndiyo nhamba yakashata yenhare iyo purogiramu ichakwezva ruzivo.
- LIE. Inoratidza kutsvaga kwekuenzanisa chaiyo. Dzimwe nguva dzimwe mimwe miganhu yezwi iri inotsanangurwa. Uye purogiramu inotarisa zvese zvinokonzera uye inotarisa zvinoshandiswa pedyo.
Zvinosuruvarisa, basa racho harigoni kushanda zvakanyanya. Mamwe data iyo mushandisi inofanira kuchengeta mupfungwa (mutsara kana nhamba yekholomu). Kana zvisina kudaro, haagoni kuwana ruzivo rwaanoda.
Nharo dzeVPR
Kuti utaure nezvekuti basa reVLOOK rinoshanda sei muExcel, unofanirwa kuzviziva nemafungiro aro. Yokutanga ndiyo kukosha kunokosha. Inogadzirisa mararamiro ekutsvaga iyo purogiramu ichatsvaga mukorori yekutanga yetafura. Haikwanise kushanda pamwe nechechipiri uye inotevera, basa racho harisi kuwana ruzivo urwu. Pakati pemutemo, nharo iyi inoratidzwa mumagwaro ekudzokorora. Kusiyanisa ndiko mazita emabasa.
Nharo yechitatu ndiyo nhamba yekholomu. Pano iwe unotsanangura ruzivo rwunoshandiswa nemunhu. Semuenzaniso, anogona kutarisa chinzvimbo chakakanganiswa nemufananidza kubva munhare yekutanga, mubhadharo wake, zviratidzo nezvimwe zvakadaro. Zvose zvinoenderana nehuwandu hwemushandisi.
Uye kuguma kwekupedzisira inopera nguva. Pano unogona kuwana "1" uye "0" kana "Nhema" ne "Chokwadi". Muchiitiko chekutanga, deta ichareva kuti kutsvaga kunowanikwa kunofananidzwa. Zvadaro purogiramu ichatsvaga mitsva yose. Kana sarudzo yechipiri inoshandiswa, zvino basa racho rinongotarisa kune zvakananga.
Zvikanganiso Zvakajairika
Iko Excel VLOOKUP basa harumbofi rakakundikana kana basa risina kunaka richionekwa. Iko ndiko kuti, mune chero kukanganisa, munhu chete ndiye anoshandisa mhosva. Pane zvikanganiso zvitatu zvakafanana. Chokutanga, munhu wacho anowanzovhiringidzika mumashoko okuti "nhema" uye "chokwadi". Yokutanga inotarisa pakuwana mutsara chaiwo. Kana iwe uchitaura kuti "chokwadi", ipapo basa rinofananidza nechokufungidzira.
Uye, chechitatu, kazhinji haisi yakarurama kuratidzira nhamba ye column inobva kune ruzivo ruzivo. Muchiitiko ichi, unofanirwa kuwedzera kaviri-chengeta data.
Unoshandisa rini basa reVLOOKUP?
Izvi zvakakodzera kutaura pamusoro penyaya. Haisi chakavanzika chokuti Excel VLOOK inoshandiswa munzvimbo dzakasiyana zvachose. Dzidziso yekushandiswa kwayo inogona kuoneka yakaoma, asi pakutanga pakuona. Kana zvisina kudaro, hazvizove zvakanyanya.
Yeuka chinhu chinokosha: basa rinotsvaga ruzivo pamusoro pechiratidzo, iyo-pamakoroni. Inoshandiswa mumamiriro akasiyana-siyana:
- Paunenge uchida kuwana ruzivo mufurafura huru kana kuwana zvose zvinyorwa zvinyorwa uye zvinoenderana.
- Mumamiriro ekudzidzisa. Mudzidzisi anogona kugara achiwana mazita evadzidzi vake munyaya yemaminiti kuti vawane kupinda kwavo, kudzidzira kwevadzidzi uye mamwe mashoko. Kunyanya, inobatsira apo urongwa hwevadzidzi hukuru, uye mudzidzisi haagoni kuyeuka mumwe nomumwe wavo.
- Muzvitoro. Kana ukashandisa basa racho kuti uwane mutengo, kuumbwa kana nhamba yenyaya, munhu wacho achakwanisa kupindura nokukurumidza mibvunzo kubva kune vatengi.
Mune shoko, mune chero mamiriro ezvinhu, kana iwe uchida kuwana deta kubva patafura, unogona kushandisa VPR.
Nzira yekushandisa sei VPR mutafura?
Hazvisi nyore kunzwisisa izvi. Kuti iyo Excel Excel fomu ishande, unofanira kutanga ita tafura. Uyewo, kuti ushandise zvakakwana basa racho, unoda mazamu maviri, iyo yakawanda nhamba yayo isingagumi.
Mazano ekushandisa basa racho
VPR mumutauro weChirungu Excel uye yakafanana nechiRussia inoshandiswa zvakaenzana. Asi kune mazano mashoma kubva kuvashandi. Kuti basa rishande zviri nani, kunyanya mushure mekushandura deta, zvinokurudzirwa kupinda murairi ye dollar pakati pearrays. Somuenzaniso, kwete A1, asi $ A $ 1. Kana hutsika dzepamusoro dzichigadziriswa, saka hapana zviratidzo kana zvikamu pakati pemazita emitsara nemirasi inofanira kuiswa.
Mhedziso
Iko Excel VLOOKUP basa (vertical view) iri nyore kumunhu ane ruzivo. Asi munhu asina ruzivo anokwanisa nyore nyore kuzivana nemitemo yekushandiswa kwayo. Mushure mekudzidzira kwavo, mushandisi achakwanisa kukurumidza kuwana ruzivo, pasinei nokuti yakawanda tafura ichave yakadii. Kana iwe uchida kushandisa maonero akareba, shandisa GPR basa.
Similar articles
Trending Now