Khangela Iinkcukacha nge-Excel UKUHLOLA Umsebenzi

Sebenzisa umsebenzi we-Excel's LOOKUP - ifom ye-vector - ukufumana ixabiso elilodwa ukusuka kumqolo omnye okanye uluhlu olulodwa lwekholomu. Funda indlela le nyathelo lihamba ngayo.

01 ngo 04

Fumana Iinkcukacha kwiikholam okanye kwiiLowula nge-Excel's LOOKUP Function

Umsebenzi we-Excel LOOKUP uneefom ezimbini:

• Ifom yeFom
• Ifom yeFayile ;

Indlela abahluke ngayo kukuba:

• Ifom ye-Array ibonakala kumqolo wokuqala okanye ikholomu yeqela-ibhloko yedatha equle imigqa emininzi kunye neikholamu - kwixabiso elithethiweyo, kwaye ubuyisela ixabiso ukusuka kwindawo efanayo kwimiqolo yokugqibela okanye ikholamu yoluhlu.
• Ifom yeFayile ihlola i-vector - umgca omnye okanye ikholomu yedatha - kwixabiso elithile kwaye ubuyisele ixabiso ukusuka kwindawo efanayo kwinqanaba lesibini okanye ikholam.

02 we 04

I-LOOKUP Umsebenzi we-Syntax kunye neArguments - Ifom yeFayile

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakethi kunye neengxabano .

I-syntax yohlobo lweVector lomsebenzi we-LOOKUP:

= LOOKUP (Lookup_value, Lookup_vector, [Result_vector])

I-Lookup_value (efunekayo) - ixabiso elikulo msebenzi likhangela kwi-vector yokuqala. I-Lookup_value ingaba yinani, isicatshulwa, isixabiso esinengqiqo, okanye igama okanye iselferensi yeseli ebhekisela kwixabiso.

I-Lookup_vector (efunekayo) - uluhlu oluqulethe umqolo omnye okanye ikholomu apho umsebenzi uphando ukufumana iLookup_value . Idatha ingaba yombhalo, amanani, okanye amanani angqiqo.

Isiphumo_vector (ukhetho) - uluhlu oluqulethe umqolo omnye okanye ikholomu enye. Le ngxabano kufuneka ibe bubungakanani obufanayo neLookup_vector .

Amanqaku:

• Ukuze umsebenzi we-LOOKUP usebenze ngokuchanekileyo, i- Lookup_vector kufuneka ihlelwe ngokunyuka komyalelo (A ukuya ku-Z okanye encinci ukuya kunkulu kumanani)
• Ukuba isigqibo se- Result_vector sishiywe , umsebenzi ubuyisela ingxabano yeLookup_value ukuba ikhoyo kwiLookup_vector
• Ukuba umsebenzi awukwazi ukufumana umdlalo ochanekileyo weLookup_value, ukhetha ixabiso elikhulu kwiLookup_vector elingaphantsi okanye elilinganayo kwixabiso leLookup_value;
• Ukuba i- Lookup_value encinci kunamanani e- Lookup_vector , umsebenzi we-LOOKUP uza kubuya impazamo ye-# N / A.

03 we 04

UKUHLOLA Umsebenzi Umzekelo

Njengoko kuboniswe kumfanekiso ongentla, lo mzekelo uya kusebenzisa ifomu leVector lomsebenzi we-LOOKUP kwifomula ukufumana intengo yeGear kuluhlu lwempahla usebenzisa uluhlu olulandelayo:

= LOOKUP (D2, D5: D10, E5: E10)

Ukulula ukwenza ukungena kweengxoxo zomsebenzi, ibhokisi yencoko yebhokisi yencoko ye -LOOKUP isetyenziswa kumanyathelo alandelayo.

1. Cofa kwiseli E2 kwiphepha lokusebenzela ukuze wenze iseli esebenzayo ;
2. Cofa kwiThebhu yefomula yemenyu yebhondi ;
3. Khetha uLookup kunye neKhonkco kwi-Ribbon ukuvula uluhlu lwehla lokuhla;
4. Cofa kwi- LOOKUP kwoluhlu ukukhupha ibhokisi yencoko yencoko yeengxoxo ;
5. Cofa kwi- lookup_value, lookup_vector, i-result_vector option kwiluhlu;
6. Cofa Kulungile ukukhupha ibhokisi yencoko yebhokisi yeeNtsebenzo;
7. Kwibhokisi yencoko, nqakraza kumgca weLookup_value ;
8. Cofa kwiseli D2 kwiphepha lokusebenzela ukufaka loo ntetho yeselenki kwibhokisi yencoko - kule selesi siza kufaka igama legama esiyifunayo
9. Cofa kumgca weLookup_vector kwibhokisi yencoko;
10. Gqamisa iiseli D5 ukuya kwi-D10 kwiphepha lokusebenzela ukuze ufake olu luhlu kwibhokisi yencoko - eli luhlu luqulethe amagama ayingxenye;
11. Cofa kwi- Result_vector line kwibhokisi yencoko;
12. Phakamisa iiseli E5 ukuya ku-E10 kwiphepha lokusebenzela ukuze ufake olu luhlu kwibhokisi yencoko - olu luhlu luqulethe amanani oluhlu lweengxenye;
13. Cofa u-OK ukugqiba umsebenzi kwaye uvale ibhokisi yencoko;
14. Iphutha le-# N / A livela kwiseli ye-E2 kuba asikafaneli ukuthayipha igama lesahlulo kwi-cell D2

04 we 04

Ukungena kwexabiso lokuLookup

Cofa kwiseli D2, thayipha i Gear uze ucinezela ukhiye wokungena kwikhibhodi

1. Ixabiso le -20.21 ye-$ limele livele kwiseli ye-E2 njengoko eli lixabiso lempahla ekhoyo kwikholamu yesibini yedatha yedatha;
2. Hlola umsebenzi ngokuthayipha amanye amagama enxalenye kwiseli D2. Ixabiso le nxalenye nganye kwoluhlu luya kubonakala kwiseli ye-E2;
3. Xa ucofa kwi-cell E2, umsebenzi opheleleyo
   = LOOKUP (D2, D5: D10, E5: E10) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela.