Batla Ditaba ka Excel HO SEBELISA Mosebetsi

Sebelisa mosebetsi oa LOLELA oa Excel - mofuta oa vector - ho fumana boleng bo le bong ho tloha ho lehlakoreng le le leng kapa lintlheng tse ngata tsa data. Ithute hore na mohato ona o tsamaeang joang ka mohato.

01 ea 04

Fumana Litsela ka Li-columns kapa Lithala ka mosebetsi oa LOOKUP oa Excel

Mosebetsi oa ho sheba oa Excel o na le mefuta e 'meli:

• Fomu ea Array
• Foromo ea Vector ;

Ho fapana ha bona ke hore:

• Foromo ea Array e sheba ka lehlakoreng la pele kapa molomong oa sehlopha - lekala la data le nang le mela e mengata le mela e mengata - bakeng sa boleng bo boletsoeng, ebe joale e khutlisetsa boleng boemong bo lekanang le molaong oa ho qetela.
• Vector Foromo e batlisisa vector - mola o le mong kapa kholumo ea data - bakeng sa tekanyetso e behiloeng ebe o khutlisetsa bohlokoa ho tloha sebakeng se le seng ka lehlakoreng la bobeli kapa khoeli.

02 ea 04

Tšebeliso ea Puo ea Syntax le Arguments - Vector Form

Syntax ea mosebetsi e bua ka boemo ba mosebetsi mme o kenyelletsa lebitso la mosebetsi, li-brackets le likhang .

Tlhaloso ea Sebopeho sa Vector ea mosebetsi oa LOOKUP ke:

= LOOKUP (Lookup_value, Lookup_vector, [Result_vector])

Nako ea ho batla (e hlokahalang) - bohlokoa boo mosebetsi o bo batlisang ka vector ea pele. The Lookup_value e ka ba nomoro, mongolo, bohlokoa bo utloahalang, kapa lebitso kapa selefouno e bolelang bohlokoa.

Ho batla-ho batla (ho hlokehang) - lebala le nang le mola o le mong feela kapa khoeli eo mosebetsi o e batlang ho fumana Lookup_value . Dintlha e ka ba melaetsa, lipalo, kapa litekanyetso tse utloahalang.

Sephetho_vector (ho ikhethela) - mebala e nang le mola o le mong kapa khoeli e le 'ngoe feela. Puisano ena e tlameha ho ba boholo bo lekanang le Lookup_vector .

Lintlha:

• Bakeng sa mosebetsi o shebang ho sebetsa ka mokhoa o nepahetseng, Lookup_vector o lokela ho hlophisoa ho nyoloha ho ea pele (A ho ea ho Z ho ea ho e nyane ho ea ho e kholo ka palo)
• Haeba khang ea Result_vector e sa lumelloe, mosebetsi o khutlisetsa phehisano ea Lookup_value haeba e teng ho Lookup_vector
• Haeba tshebetso e sitoa ho fumana papiso e tobileng ea Lookup_value, e khetha boleng bo boholo ka ho fetisisa ho Lookup_vector e ka tlaase ho kapa e lekanang le ea bohlokoa ho Lookup_value;
• Haeba Lookup_value e nyenyane ho feta litekanyetso tsohle tsa Lookup_vector , mosebetsi oa LOOKUP o tla khutlisa phoso ea # N / A.

03 ea 04

MOSEBETSI OA HO SEBELISA Mohlala

Joalokaha ho bonngoe setšoantšong se ka holimo, mohlala ona o tla sebelisa Foromo ea Vector ea mosebetsi oa LOOKUP ka mokhoa oa ho fumana theko ea Gear lenaneng la lihlahisoa ka mokhoa o latelang:

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

Ho nolofalletsa ho kenela liphapang tsa mosebetsi, LOOKUP function dialog box e sebelisoa mehatong e latelang.

1. Tobetsa ho cell E2 kahare ho etsa hore e be sele e sebetsang ;
2. Tobetsa Tlhahlobo ea temo ea menu;
3. Khetha ho lata le ho buella ho tswa ho lithane ho bula lenane la ho theoha mosebetsing;
4. Tobetsa ho RELETSA lethathamong la ho hlahisa lebokose la lihlooho tsa lebokose la lihlooho;
5. Tobetsa ho lookup_value, lookup_vector, result_vector kgetho;
6. Tobetsa OK ho hlahisa lebokose la lihlopha tsa lebokose la Function ;
7. Ka lebokoseng la lebokose, tobetsa molaong oa Lookup_value ;
8. Tobetsa seleng D2 kahare ho etsa hore re kenye li-cell reference ka lebokose la lebokoseng - sele ena re tla ngola lebitso la karolo eo re e batlang
9. Tobetsa mohala oa Lookup_vector lebokoseng la dialog;
10. Totobolla lisele tsa D5 ho D10 kahare ea lipampiri ho kenya lebokose lena lebokoseng la lebokose - mobu ona o na le mabitso a karolo;
11. Tobetsa mofuteng oa sephetho_a ho etsa lebokoseng la dialog;
12. Totobolla lisele tsa E5 ho ea ho E10 mosebetsing oa ho kenya boemong bona lebokoseng la lebokose lena - lethathamo lena le na le litheko tsa lenane la likarolo;
13. Tlanya Kantle ho qeta mosebetsi mme u koale lebokose la lebokose;
14. Phoso ea # N / A e hlahella seleng ea E2 hobane ha re e-s'o thaelele lebitso la karolo ka seleng ea D2

04 ea 04

Ho kenya Letlotlo la ho Lokelap

Tobetsa ho cell D2, mofuta oa Gear 'me u tobetse ho kenya senotlolo lebokoseng

1. Chelete ea $ 20.21 ea bohlokoa e lokela ho hlaha ka seleng ea E2 kaha ena ke tefo ea liphase tse ka har'a mohala oa bobeli oa tafoleng ea data;
2. Hlahloba mosebetsi ka ho thapa mabitso a mang a karolo ka seleng ea D2. Theko ea karolo e 'ngoe le e' ngoe lethathamong le tla hlaha seleng ea E2;
3. Ha o tobetsa ka cell E2, mosebetsi o feletseng
   = LOOKUP (D2, D5: D10, E5: E10) e hlaha kahare ea foromo ka holim'a leqephe la mosebetsi.