CDF Excel - yintoni na? Funda ukusebenza ngayo Excel VLOOKUP

CDF Excel - ayiveli kwinkqubo efanelekileyo, nto leyo zizakubalulwa ubuhle bayo lula. Kuye izicelo ezininzi ezahlukeneyo, lisetyenziswa kwiindawo ezahlukeneyo ngokupheleleyo: kwimfundo kunye nesiphelo kunye urhwebo. Le ngcamango umsebenzi kukuba ukukhangela nomdlalo iitafile omnye okanye ngaphezulu. Ngoko unako lula ukufumana ulwazi kunye ubuncinane ixesha.

ulwazi jikelele

VLOOKUP Excel - yintoni na? Saziwa kwi kwinguqulelo IsiNgesi-ngolwimi VLOOKUP. Le yenye yezona eqhelekileyo imisebenzi kunye links ma. Iingcali ekulelona isikali BRP IMG, izinga lobunzima sile kubalwe 3 okanye 7.

feature Izincomo kukuvumela ukuba ufumane itafile enkulu amaxabiso kweengcamba okanye imiqolo eziyimfuneko kumsebenzisi. Eyokuqala i parameter yale nkqubo ngokwayo. Ikholam esicacisiweyo umsebenzisi. Kukho omnye umsebenzi PGR, apho umntu iphawulwe umgca. Column akafumani ezabo.

Ukuba umsebenzisi sele kwafuneka lijongane iimbekiselo kunye kwimiboniso, uze uhlolisise ezi iintshukumo CDF iza kuba lula. Amaxwebhu table ezahlukeneyo inokuba Umbhalo kwiseli ethile. Naye up umzekelo, okanye, icala, eziboniswe njengezehlelo umnyinyiva. Lo msebenzi VPR lidla kubonisiwe njenge iseli A1, D9, uK8 njalo njalo.

Maxa wambi, reference ikhutshwa ngolunye uhlobo (R1C1). Ngokufutshane, kukho ikholam kunye umgca ekudibaneni kwaye kuyimfuneko ulwazi lomsebenzisi le. Le nkqubo ifumana isalathiso ngqo apho kuyimfuneko ukukhangela le data.

Parameters kulo mzekelo

Ezona mpawu CDF Excel okokuqala inani line, kulandele isiqu kwikholam. Malunga kufuneka afumane into efana:

YePPM = (A1; data_base 2, FALSE)

Iparameters kulo mzekelo zimi ngolu hlobo lulandelayo:

1. A1. Le inkomba luqikelelo ukuya esiseleni. It lingaba naliphi na ixabiso, kuxhomekeka yoko, apho umsebenzisi ufuna ukufumana.
2. Dbname. Igama yentsimi ulwazi ufuna. Ingcinga ayikho nje ngokubanzi njengoko ezidlulileyo. Ingasetyenziswa kuphela lukrozo lokuqala okanye umhlathi.
3. 2. Eli isalathiso inani kwikholam apho le nkqubo iya kukha ulwazi.
4. FALSE. It ibonisa ngqo kumdlalo search. Ngamanye amaxesha wabhekisela kwezinye izilungiselelo zelizwi. Yaye ngoxa le program iya ukukhangela zonke izenzeko yaye zijongisise ixabiso elandelayo.

Ngelishwa, lo msebenzi akavumelekanga ukuba asebenze ngaphezulu ngobungcali. Ezinye iinkcukacha umsebenzisi kufuneka sikhumbule (inombolo umqolo okanye column). Kungenjalo, akayi kuba nako ukufumana ulwazi alisweleyo.

iimpikiswano CDF

Ukuze sithethe CDF umsebenzi Excel, kufuneka njani aqhelane ngeengcebiso zayo. Eyokuqala ixabiso olifunayo. Icacisa iikhrayitheriya eziya kuba ufuna inkqubo kwikholam yokuqala itafile. Kusenokuba akusebenzi umsebenzi kwesibini nje abayi kufumana olu lwazi. Ngaphakathi ifomula kunjalo iboniswe kuchaphulo. Ezi nketho la amagama kwemisebenzi.

Enye impikiswano - itafile. Oko icaciswe a nokulawula inkqubo. Kwaye ngqo kule theyibhile, kwikholam yokuqala umsebenzi wayo uya kuzama ukufumana into oyifunayo. Waqale wabonisa (bona. Ngaphezu).

Le ngxoxo sesithathu - inombolo kwikholam. Apha ungakhankanya ulwazi umsebenzisi nasifunayo yena. Ngokomzekelo, yena uyakwazi ukubona ehambelana amagama kwikholam yokuqala, umvuzo wakhe, uphawu njalo njalo. Konke kuxhomekeke imihlaba umsebenzi umsebenzisi.

Le ngxoxo lokugqibela - imboniselo lekhefu. Apha ungakhankanya "1" kunye "0" okanye "Wamanga" kunye "I ntiyiso." Kwimeko yokuqala, i-data kuya kuthetha ukuba ukufuna elikhankanyiweyo kulinganisiwe. Ngoko ke inkqubo iya kuqala ukukhangela yonke imidlalo. Ukuba usebenzisa i yesibini khetho, ngoko ke umsebenzi uya kuhlawula ingqalelo kuphela kumaxabiso ngqo.

iimpazamo eziqhelekileyo

Umsebenzi Excel VLOOKUP soze isebenze kakuhle ukuba umsebenzi kumakishwa engalunganga. Oko kukuthi, naziphi na ukunyhashwa isiphoso lomsebenzisi. Kukho iimpazamo ezintathu eziqhelekileyo. Okokuqala, umntu udla sididekile ukuxambulisana 'ubuxoki' kunye 'inyaniso. " Eyokuqala esijolise khangela kumdlalo ngqo. Ukuba awukhankanyi "oyinyaniso", ngoko ke umsebenzi ayichole ballpark.

Okwesibini, Excel CDF ifomula ayikwazi ezenzelwe oko ukuba ukhangelo luqala kwiikholam wesibini okanye olandelayo. Fumana idata kuba ngabokuqala kuphela. Ngoko ke, ukuba umsebenzisi ongena ezinye ifomula olwahlukileyo imithetho, inkqubo iya nje kuba nako ukuyibona.

Kwaye, okwesithathu, ngokufuthi ngokungachanekanga ibonisa inombolo kwikholam, apho ulwazi olufunekayo. Kulo mzekelo, kufuneka kabini-hlola data.

Xa usebenzisa umsebenzi CDF?

Oku kuyimfuneko ukuthetha ngokweenkcukacha. Yinto akukho mfihlakalo ukuba kwiinkalo ezahlukeneyo ngokupheleleyo kusetyenziswa CDF Excel function. Imiyalelo yokusebenzisa indlela nzima, kodwa kuphela xa efika kuqala. Kungenjalo yena wayengayi kuba zande kangaka.

Khumbula into ezinkulu: umsebenzi uphengulula ulwazi malunga nkqo, oko kukuthi - kwiikholam. Oku asetyenziswa kwimiba neemeko ezahlukeneyo:

• Xa kuyimfuneko ukufumana ulwazi kwetafile enkulu okanye ukhangele ukuba naziphi na iinkcukacha zinedyuplikhethi kwaye ukuqondana.
• Imeko lokufundisa. Utitshala angasoloko igama abafundi babo kumcimbi mathuba bafumane yokubasemsebenzini kwabo, indlela abaqhuba ngayo esikolweni, kunye nolunye ulwazi. Ngokukodwa, oko kuluncedo xa uluhlu elikhulu labafundi, utitshala awukhumbuli ngamnye kubo.
• Kurhwebo neevenkile. Ukuba usebenzisa umsebenzi a ukukhangela amaxabiso, ukwakhiwa okanye inqaku kwempahla, loo mntu uya kuba nako ukuphendula ngokukhawuleza anemibuzo kubathengi.

Ngokufutshane, kuyo nayiphi na indawo apho ufuna ukufumana idata evela itafile, ungasebenzisa i CDF.

Indlela yokusebenzisa le CDF kwitheyibhile?

Qonda oku akukho nzima. To Excel VLOOKUP ifomyula lusebenza ngokwenene, ekuqaleni kufuneka ukuba wenze itafile. Kwakhona, ukuba ukusetyenziswa ngokupheleleyo umsebenzi kufuna imihlathi ubuncinane ezimbini, inani lobuninzi ezinjalo - akupheleli.

Emva koko, ngo iseli engenanto, faka ifomula, apho umsebenzisi lixela ngamabona iikhrayitheriya nolwazi. An niche engenanto kungenziwa akhiwe naphi na, ukusuka phezulu, ezantsi, ekunene. Iiseli kufuneka kwandiswe, ukuze ufumane iinkcukacha. Ekubeni izinze kwimiqolo zabo, kufuneka ubuncinane ezimbini. Ukuba iinketho zophendlo ngakumbi, kwaye inani leseli ukunyuka. ekungqinweni umsebenzi ngoko owenziweyo kunye nobungakanani wokubala kwathiwa esiyinyaniso. Ukuze wenze oku, nqakraza kwi "amaxabiso imbono." Kuyenzeka ukuba ukubhaqa ukungangqinelani kwifomula.

Iingcebiso malunga nokusetyenziswa umsebenzi

CDF Excel e IsiNgesi kunye analogue Russian lisetyenziswa ngokulinganayo. Kodwa kukho ezimbalwa iingcebiso ezivela iingcali. Zivumela ukuba asebenze bhetele, ingakumbi xa utshintsho data, kucetyiswa ukuba ufake uphawu lwedola phakathi amaqoqo. Ngokomzekelo, hayi A1, kwaye A $ 1 $. Xa iqhutywa amaxabiso zaseprayimari, akukho abalinganiswa izithuba phakathi kwemigca kunye namagama zomhlathi akukho mfuneko ukuba.

Kukwacetyiswa kwakhona ukuba bayitshekishe ngocoselelo etafileni ukuze iziphumlisi olungeyomfuneko okanye izithuba. Ubukho babo akavumi inkqubo ukukhangela kakuhle kwimidlalo, ingakumbi xa kuphela uqikelelo (kwi "Inyaniso" parameter).

isiphelo

Umsebenzi Excel VLOOKUP (buka nkqo) kulula ukuba umsebenzisi onamava. Kodwa abangenamava kulula ukubuza umntu uya kuba nolwazi kunye nemigaqo yokusetyenziswa kwayo. Emva uphuhliso lwabo umsebenzisi uza kukwazi ukufumana ulwazi ngokukhawuleza, kungabikho ndaba netafile enkulu kangakanani. Ukuba kufuneka usebenzise imbono tyaba, umsebenzi uya isebenze PGR.