CDF Excel - kuyini? Funda indlela ukusebenza Excel VLOOKUP

CDF Excel - isici uhlelo olufanele, okuyinto zihlukaniswa ubuhle baso futhi engeyona inkimbinkimbi. It has izicelo eziningi ezahlukene, isetshenziswa ezindaweni ezahlukene ngokuphelele: emfundweni ziphethe ukuhweba iimfesi. Umqondo oyisisekelo komsebenzi ukucinga nomdlalo nethebula elilodwa noma ngaphezulu. Ngakho ungakwazi kalula ukuthola ulwazi nge okungenani isikhathi.

ulwazi olujwayelekile

VLOOKUP Excel - kuyini? It is eyaziwa kule nguqulo lesiNgisi of VLOOKUP. Lona omunye ezivamile imisebenzi nezixhumanisi afanayo. Ochwepheshe akha isikali BRP ISELULEKO, embukisweni nobunzima level, akhiwa 3 noma 7.

sici Kubhekwe ikuvumela ukuba ngokushesha ukuthola itafula elikhulu abakuzuzile imigqa noma amakholomu ezidingekayo umsebenzisi. Umngcele we-lokuqala lolu hlelo okungokwalo. Ikholomu eshiwo umsebenzisi. Kunenye umsebenzi PGR, lapho umuntu ephawulwe umugqa. Ikholomu aluthole bebodwa.

Uma umsebenzisi wayevele ukubhekana izithenjwa afanayo, cabanga ke izenzo CDF kuyoba lula. Imibhalo ithebula ezahlukene kungaba waphansi yeseli esithile. Wakhe njengesibonelo, noma, Ngakolunye uhlangothi, wabonisa njengoba ushwele. Umsebenzi for VPR ngokuvamile wabonisa njengoba kuseli A1, D9, K8 nokunye.

Ngezinye izikhathi, inkomba ihlinzekwa ngenye indlela (R1C1). Kafushane, kukhona ikholomu futhi umugqa ezimpambanweni zomgwaqo futhi okuyilona elidingekayo ukuze umuntu ulwazi umsebenzisi. Uhlelo uthola liyisibonelo okunembile lapho kuyadingeka ukuze useshe idatha.

Amapharamitha ngesibonelo

Izici CDF Excel abokuqala ecacisiwe Inambalayini, kulandele isiqu ikholomu. Cishe kufanele uthole into efana:

PPS = (A1; data_base 2, FALSE)

Amapharamitha Kulokhu zimi kanje:

1. A1. Lena inkomba eseduze yeseli. Kungaba yiliphi inani, kuncike yalokho, lapho umsebenzisi ufuna ukuthola.
2. Dbname. Igama lenkambu lokwaziswa okufanele ngifuna. Umqondo akuyona njengoba olunzulu njengoba kunguye odlule. It ingasetshenziswa kuphela ngenxa umugqa noma ikholomu yokuqala.
3. 2. Lena yinombolo Inkomba kukholamu lapho uhlelo ngizodonsela ulwazi.
4. FALSE. Ikhombisa i ngqo umdlalo yokusesha. Ngezinye izikhathi abaphefumulelwe babhekisela kwezinye izilungiselelo eziseqophelweni izwi. Futhi ngenkathi uhlelo abayofuna kuzo zonke izindawo elivela futhi ukunquma ukubaluleka esilandelayo.

Ngeshwa, lokhu umsebenzi kungenzeka zingasebenzi ngaphezulu efanele. Enye idatha yomsebenzisi kudingeka khumbula (inombolo irowu noma ikholomu). Uma kungenjalo, ngeke ukwazi ukuthola ulwazi akudingayo.

agumenti CDF

Ukuze ukhulume ngendlela CDF umsebenzi Excel, udinga ngijwayele agumenti ayo. Esokuqala ukubaluleka oyifunayo. Icacisa ezibhekwayo uzobe ngifuna uhlelo kukholamu yokuqala etafuleni. Kungenzeka singasebenzi umsebenzi yesibili futhi okwalandela nje ngeke uthole lolu lwazi. Ngaphakathi ifomula ukuthi ingxabano kuvezwa izingcaphuno. Okukhishiwe amagama imisebenzi.

Enye impikiswano - etafuleni. Singasho elicacisiwe Ukudidiyela uhlelo. Futhi ngokuqondile kuleli thebula, ikholomu yokuqala umsebenzi walo izozama ukuthola into oyifunayo. Yena wabonisa (bheka. Ngenhla).

Eyesithathu agumenti - inombolo kukholomu. Lapha ucacise ulwazi ukuthi umsebenzisi ufuna. Ngokwesibonelo, lapho ungabona isikhundla elihambisana amagama kukholamu yekucala, inkokhelo yaso, uphawu nokunye. Konke kuncike kwenkululeko umsebenzi umsebenzisi.

I last agumenti - umbono isikhawu. Lapha ucacise "1" futhi "0" noma "Amanga" futhi "Uqinisile." Esimweni sokuqala, idatha kuzosho ukuthi Ukusesha okushiwo eseduze. Khona-ke lolu hlelo luyoba ukuqala ukucinga konke ukufana. Uma usebenzise inketho yesibili, khona-ke umsebenzi ozonaka kuphela amagugu ngqo.

amaphutha ezivamile

Umsebenzi Excel VLOOKUP akasoze isebenze kahle uma umsebenzi ephawulwe okungalungile. Okungukuthi, noma yimuphi ukwephulwa iphutha yomsebenzisi. Kukhona amaphutha ezintathu ezivamile. Okokuqala, umuntu ngokuvamile kwengqondo emaphuzwini "amanga" futhi "iqiniso." Esokuqala igxile Ukufuna umdlalo ngqo. Uma ucacise "iqiniso", ngakho-ke umsebenzi ucosha ballpark.

Okwesibili, i-Excel CDF ifomula ayikwazi oqokiwe ukuze search iqala amakholomu kwesibili noma izikhathi ezilandelanayo. Thola idatha kungaba kuphela kuqala. Ngakho-ke, uma umsebenzisi ungena ezinye ifomula ehlukile imithetho, uhlelo uyomane ngeke bakwazi ukuyibona.

Futhi, okwesithathu, ngokuvamile ngokungalungile kubonisa isibalo ikholomu, lapho ulwazi kuyadingeka. Kulokhu, udinga uhlole idatha.

Lapho usebenzisa umsebenzi CDF?

Lokhu kuyadingeka ukuze ukhulume ngokuningiliziwe. Kuyinto imfihlo ukuthi sphere ngokuphelele ezahlukene ezisetshenziswa CDF Excel umsebenzi. Imiyalelo sendlela yokusebenzisa kungase kube yinto esabekayo, kodwa kuphela efika kuqala. Kungenjalo wayengeke zande kangaka.

Khumbula into esemqoka: umsebenzi efuna ulwazi mpo, okungukuthi - e amakholomu. Isetshenziselwa etimeni letehlukene:

• Lapho kubalulekile ukuba uthole ulwazi kwetafula elikhulu eliphakeme noma afune noma iyiphi idatha impinda futhi nje ukuqondana kwezinto.
• Imvelo nokufundisa. Uthisha angakwazi njalo igama abafundi babo indaba izikhathi ukuthola khona kwabo, ukufunda kwawo esikoleni, kanye neminye imininingwane. Ikakhulukazi, kuyasiza uma uhlu elikhulu labafundi, nekutsi thishela usebente ngeke bakhumbule ngamunye wabo.
• Esikhathini ukuhweba iimfesi. Uma usebenzisa umsebenzi ukucinga amanani, ukwakheka noma sihloko kwezimpahla, umuntu uzokwazi asabela ngokushesha imibuzo yabathengi.

Kafushane, kunoma iyiphi indawo lapho udinga ukuthola idatha kusuka etafuleni, ungasebenzisa CDF.

Indlela yokusebenzisa CDF ethebuleni?

Qonda lokhu akunzima. Ukuze Excel VLOOKUP ifomula isebenza ngempela, ekuqaleni kuzomele wenze itafula. Futhi, ukuze ukwazi ukusebenzisa ngokugcwele umsebenzi kudinga amakholomu okungenani ezimbili, ubuningi benombolo yama ezinjalo - akugcini.

Khona-ke, ngo-eyeseli elingenalutho, faka ifomula, lapho umsebenzisi icacisa nenqubo zenzakalo nolwazi. Kuvele niche ezingenalutho kungenziwa akhiwe kuphi: ukusuka phezulu, phansi, kwesokudla. Amaseli kudingeka ukwandisa, ukuthola idatha. Njengoba zitholakala amakholomu zabo, badinga okungenani ezimbili. Uma okukhethwa yosesho, futhi inani lamaseli iyakhula. sokuqinisekisa umsebenzi wabe eseya lapho kanye nendlela ifomula kulotshiwe okuyinto kuyiqiniso. Ukuze wenze lokhu, chofoza "umbono namagugu." Kungenzeka ukuthola nokushintshashintsha ifomula.

Izincomo ngokusetshenziswa kwemikhiqizo ye- umsebenzi

CDF Excel ngesiNgisi kanye Analogue Russian sisetshenziswa ngokulinganayo. Kodwa kukhona amathiphu ambalwa kusukela ochwepheshe. Ukuze isici ukuze asebenze kangcono, ikakhulukazi uma ushintsho idatha, kutuswa ukungena uphawu dollar phakathi afanayo. Ngokwesibonelo, hhayi A1, ne A $ 1 $. Lapho esibethelwe amagugu eyinhloko, azikho izinhlamvu kanye nezikhala phakathi kwemigqa namagama ikholomu akudingeki ukubeka.

It is ibuye Kunconywa ukuba siyihlolisise etafuleni ukugwema izimpawu zokubhala ezingadingekile noma izikhala. Ukuba khona kwabo akuvumeli uhlelo kahle ukucinga okufanayo, ikakhulukazi uma kuphela eseduze (ku "Iqiniso" ipharamitha).

isiphetho

Umsebenzi Excel VLOOKUP (buka mpo) ilula umsebenzisi abanolwazi. Kodwa ungenalwazi kulula embuzweni umuntu uyoba ujwayelene imithetho yokusetshenziswa kwawo. Ngemva ukuthuthukiswa yabo umsebenzisi uzokwazi ukuthola ulwazi ngokushesha, nge kungakhathaliseki olunzulu ngeke etafuleni kanjani. Uma kufanele asebenzise umbono evundlile, umsebenzi izoqaliswa PGR.