Bincika Bayanai tare da Ayyukan Lissafi na Excel

Yi amfani da aikace-aikacen LOOKUP na Excel - siffar samfurin - don sake samo ɗaya daga ma'auni ɗaya ko jere guda ɗaya na bayanai. Koyi yadda za a jagoranci wannan mataki zuwa mataki.

01 na 04

Nemo bayanai a ginshiƙai ko Rukunai tare da aikin Excel na aikin LOOKUP

Ayyukan LOOKUP na Excel yana da nau'i biyu:

• da Array Form
• siffar takarda ;

Yadda suke bambanta shi ne:

• Tsarin Array ya dubi jeri na farko ko shafi na tsararre - wani asalin bayanai wanda ya ƙunshi layuka da ginshiƙai masu yawa - domin ƙimar da aka ƙayyade, sa'annan ya dawo da darajar daga matsayi daya a jere na ƙarshe ko shafi na jeri.
• Fayil na Vector ya nema wani samfurin - jere guda ɗaya ko shafi na bayanai - don darajar da aka ƙayyade sannan sannan ya sake dawo da darajar daga matsayi guda a jere ko jeri na biyu.

02 na 04

Lissafi na Tasirin LOKACI DA GUDATARWA - Fom ɗin Firayi

Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara .

Hadawa don Dokar Vector na aikin LOOKUP shine:

= Binciken (Lookup_value, Lookup_vector, [Result_vector])

Lookup_value (da ake buƙata) - darajar da aikin ke nema a cikin kundin farko. Ƙaƙidar Lookup_value na iya zama lamba, rubutu, ma'ana mai mahimmanci, ko sunan ko ƙirar salula wanda yana nufin darajar.

Lookup_vector (da ake buƙata) - wani kewayon da ke dauke da jere daya kawai ko shafi da aikin ke nema don gano Lookup_value . Bayanai na iya zama rubutu, lambobi, ko dabi'u masu mahimmanci.

Result_vector (na zaɓi) - wani kewayon da ya ƙunshi kawai jere ko shafi. Wannan hujja dole ne girman daidai kamar Lookup_vector .

Bayanan kula:

• Don aikin aikin LOOKUP ya yi aiki daidai, dole ne a ware cikin Lookup_vector cikin tsari mai girma (A zuwa Z ko mafi ƙanƙanta ga mafi girma ga lambobi)
• Idan an tsayar da hujjar Result_vector , aikin zai dawo da binciken Lookup_value idan ya kasance a Lookup_vector
• Idan aikin ba zai iya samun daidaito daidai ga Lookup_value ba, zai zaɓi mafi girma a cikin Lookup_vector wanda bai fi daidai ba ko kuma daidai a cikin darajar Lookup_value;
• Idan Lookup_value ya fi dukkan ƙa'idodi a cikin Lookup_vector , aikin LOOKUP zai dawo da kuskuren N / A.

03 na 04

Sakamakon aikin haɗi Misali

Kamar yadda aka gani a cikin hoton da ke sama, wannan misali zai yi amfani da nau'i na Vector Form na aikin LOOKUP a cikin wata hanya don samo farashin Gear a lissafin kaya ta yin amfani da wannan tsari:

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

Don sauƙaƙe shigar da muhawarar aikin, ana amfani da akwatin maganganu na LOOKUP a cikin matakai na gaba.

1. Danna kan salula E2 a cikin takardun aiki don sanya shi tantanin halitta ;
2. Danna maɓallin Formulas na shafin ribbon ;
3. Zabi Duba da kuma Magana daga ribbon don buɗe jerin aikin sauke aikin;
4. Danna kan LOOKUP a cikin jerin don kawowa da Zaɓin zance zane-zane;
5. Danna kan lookup_value, lookup_vector, option_vector wani zaɓi cikin jerin;
6. Danna Ya yi don gabatar da akwatin maganganu na Magana ;
7. A cikin akwatin maganganu, danna kan layin Lookup_value ;
8. Danna kan tantanin halitta D2 a cikin takardar aiki don shigar da wannan tantanin halitta a cikin maganganun maganganu - a wannan tantanin halitta za mu rubuta sunan ɓangaren da muke nema
9. Danna kan layin Lookup_vector a cikin akwatin maganganu;
10. Sanya ɗakunan D5 zuwa D10 a cikin takardun aiki don shigar da wannan tashar a cikin akwatin maganganun - wannan tashar yana dauke da sunayen yanki;
11. Danna maɓallin Result_vector cikin akwatin maganganu;
12. Fassara sel E5 zuwa E10 a cikin takardar aiki don shigar da wannan tashar a cikin akwatin maganganun - wannan kewayon ya ƙunshi farashin lissafin sassa;
13. Danna Ya yi don kammala aikin kuma rufe akwatin maganganu;
14. An sami kuskuren N / A a cikin cell E2 saboda ba mu daina rubuta sunan ɓangaren cikin tantanin halitta D2

04 04

Shigar da Darajar Bincike

Danna kan tantanin halitta D2, rubuta Gear kuma latsa maɓallin Shigar da ke keyboard

1. Darajar $ 20.21 ya kamata ya bayyana a cikin cell E2 kamar yadda wannan farashin kaya yake a cikin shafi na biyu na tarin bayanai;
2. Gwada aikin ta rubuta wasu sassan sunaye zuwa cikin cell D2. Farashin ga kowane ɓangare a cikin lissafi zai bayyana a cell E2;
3. Lokacin da ka danna kan tantanin halitta E2, cikakken aikin
   = LOKACI (D2, D5: D10, E5: E10) ya bayyana a cikin maɓallin tsari a sama da takardun aiki.