Tsvaga Dhiyabhorosi neExcel LOOKUP Function

Shandisa Excel's LOOKUP function - fomu yevector - kutora chinhu chimwe chete kubva kune rimwe rutsara kana imwe-khoma yakatarwa yedata. Dzidza kuti sei danho rino nehanho rinotungamirira.

01 ye 04

Tsvaga Dhiyabhorosi muColumns kana Rows neExcel LOOKUP Function

Excel's LOOKUP basa ine mafomu maviri:

• The Formula Form
• Vector Form ;

Iyo yakasiyana sei ndeyokuti:

• Nzira yeArray inotarisa mumutsara wokutanga kana koromo ye- array -ibhuku re data rine mibhodi yakawanda nemadzamu - nokuda kwehuwandu hwakatarwa, uye inodzorera kukosha kubva panzvimbo imwechete mumuganhu wekupedzisira kana korombo yezvakanyorwa.
• Iyo Vector Form inotsvaga vector - musara mumwe chete kana koromo ye data - nokuda kwehuwandu hunotsanangurwa uye zvino kudzorera kukosha kubva panzvimbo imwechete mumutsara wechipiri kana korombo.

02 of 04

The LOOKUP Function Syntax uye Arguments - Vector Form

Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .

Mutsara weVector Form we LOOKUP basa nderekuti:

= LOOKUP (Lookup_value, Lookup_vector, [Result_vector])

Lookup_value (inodikanwa) - kukosha kwokuti basa rinotsvaga muvaki yekutanga. Iko Lookup_value inogona kuva nhamba, zvinyorwa, kukosha kwepamusoro, kana zita kana sero rekuti rinoreva kukosha.

Lookup_vector (inofanirwa) - rutsanga rune mutsara mumwe chete kana koromo iyo basa rinotsvaga kuti riwane Lookup_value . Dheta inogona kuva mutsara, nhamba, kana kuti maonero akanaka.

Result_vector (optional) - bhora rine mutsara mumwe chete kana koromo. Iyi nharo inofanira kunge yakaenzana nekukura seLookup_vector .

Notes:

• Nokuti LOOKUP basa kushanda zvakanaka, Lookup_vector inofanira kusarudzwa mukukwira urongwa (A kusvika Z kana zviduku kusvika kuvakuru kune nhamba)
• Kana Sarudzo_vector argument isingabvumirwi, basa rinodzorera mhinduro ye Lookup_value kana iripo muLookup_vector
• Kana basa racho risingagoni kuwana mutsara chaiwo weLookup_value, inosarudza kukosha kukuru muLookup_vector iyo iri pasi kana kuti yakaenzana neyako kuLookup_value;
• Kana iLookup_value iri duku kudarika nheyo dzose muLookup_vector , basa re LOOKUP richadzoka # N / A kukanganisa.

03 of 04

LOOKUP Function Example

Sezvakaratidzwa mumufananidzo uri pamusoro, muenzaniso uyu uchashandisa Vector Form ye LOOKUP basa mune imwe nzira yekuwana mutengo weGear muurongwa hwekutsvaga uchishandisa inotevera inotevera:

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

Kuti uite nyore kupinda mumashandisirwo emabasa, LOOKUP function dialog box inoshandiswa mumatanho anotevera.

1. Dzvanya pachitokisi E2 mune pepa rekushanda kuti uite sero rinoshanda ;
2. Dzvanya paMafomu tab yebhoni yebhoni ;
3. Sarudza Kuona uye Kutarisa kubva kubhoni kuti uzarure basa rinoderedza pasi;
4. Dzvanya pa LOOKUP munyaya kuti uuye neSarudzo dzinopikisana nebhokisi rebhokisi;
5. Dzvanya pane lookup_value, lookup_vector, result_vector sarudzo mukati mutsamba;
6. Dzvanya OK kuti uwedzere Basa reArguments dialog box;
7. Mubhokisi rebhokisi, tora paLowokup_value line;
8. Dzvanya pane cell D2 mune pepa rekushandisa kuti uise iyo seferensi iri mubhokisi rebhokisi - muchitokisi ichi tinonyora chikamu chechikamu chatiri kutsvaga
9. Dzvanya paLookup_vector line mubhokisi rebhokisi;
10. Simbisai masero D5 kusvika D10 mubasa rekushandisa kuti uise urwu mubhokisi rebhokisi - iri bhora rine mazita ekuti;
11. Dzvanya paGumisiro_kutevedza mubhokisi rebhokisi;
12. Simbisai masero E5 kusvika E10 mubasa rekushandisa kuti uise urwu mubhokisi rebhokisi - urwu huno hutengo hwemutsara wezvikamu;
13. Dzvanya OK kuti upedze basa uye uvhare bhokisi rebhokisi;
14. An # N / A kukanganisa kunooneka muchitokisi E2 nokuti hatisati tinyora chikamu chechikamu muchitokisi D2

04 we 04

Kupinda Kukosha Kwekuona

Dzvanya pane cell D2, gadzidza Gear uye diya Enter Enter pane keyboard

1. Iko inokosha $ 20.21 inofanira kuonekwa muchitokisi E2 sezvo ichi chiri mutengo we gear iri mukombodhi yechipiri yedhafura yedhakwa;
2. Edza basa racho nekunyora mamwe mazita mazita muchitokisi D2. Mutengo wezvikamu chimwe nechimwe muurongwa uchaonekwa muchitokisi E2;
3. Paunenge uchinyora pa cell E2, basa rakakwana
   = LOOKUP (D2, D5: D10, E5: E10) inowanikwa mubhadharo yepamusoro pane pepa pepaji.