E huli i nāʻikepili me ka hana Excel LOOKUP

E hoʻohana i ka hana LOOKUP o Excel - kiʻi vela - e kiʻi i kahi helu hoʻokahi mai hoʻokahi lālani a hoʻokahi o ka pae o kaʻikepili. E aʻo i keʻano o kēia alakaʻiʻana i kēlā me kēia lā.

01 o 04

E huli i kaʻikepili i nā kolamu a i nā laina me ka hana LOOKUP a Excel

Loaʻa ka hana LOOKUP a Excel iʻelua mauʻano:

• ke pepa palapala
• ke kiʻi Vector ;

Pehea lākou i like ai:

• Ke nānā aku nei keʻano o nā kiʻi ma ka lālani mua a me ke kalani o ka pūʻali - kahi'āpana o nā helu i loaʻa nā lālani a me nā kolamu - no ka helu i'ōleloʻia, a laila e hoʻi mai i kahi waiwai mai kahi kūlana i ka laina hope a iʻole ka pae o ka pūnaewele.
• Huli ka Vector Form i kahi vector - he laina hoʻokahi a he kolamu o nāʻikepili - no ka helu i'ōleloʻia a laila e hoʻihoʻi i ka waiwai mai kahi kūlana ma kahi lainaʻelua a iʻole ke kalani.

02 o 04

ʻO ka LOOKUP Pūkaʻina Haʻina a me nā Hoʻopilikia - Vector Form

ʻO ka'ōkuhi o kahi hana e pili ana i ka hoʻolālā o ka hana a me ka inoa o nā hana, nā pale, a me nā manaʻo .

ʻO ka syntax no ka Vector Form of the LOOKUPʻoihana:

= LOOKUP (Lookup_value, Lookup_vector, [Result_vector])

Lookup_value (makemakeʻia) - kahi waiwai e huli ai ka hana ma ka velem mua. Hiki i ka Lookup_value ke helu, ka leka, ke kumu waiwai, a iʻole ka inoa a iʻole ka pilina pili i pili i kahi waiwai.

Lookup_vector (makemakeʻia) - kahi i loaʻa i kahi lālani aiʻole ka tīwae wale nō eʻimi ai ka hana i ka huli Lookup_value . Hiki i nāʻikepili ke helu, nā helu, aiʻole nā ​​helu loiloi.

Result_vector (kohoʻole) - kahi kikowaena i loaʻa wale kahi laina a iʻole ka pae. Pono kēia kūlana e like me Lookup_vector .

Nā memo:

• No ka hana pono o ka LOOKUP , pono e hoʻonuiʻia ka Lookup_vector ma ke kauoha piʻi (A hiki i Z aiʻole liʻiliʻi i ka nui no nā helu)
• Inā haʻalele ka Huahana Result_vector ,ʻo ka hana e hoʻihoʻi i ka manaʻo Lookup_value ināʻo ia ma Lookup_vector
• Ināʻaʻole hiki keʻike i kahi kikowaena no ka Lookup_value, kohoʻo ia i ka waiwai nui loa ma ka Lookup_vector i emi iho aʻoi like paha i ka waiwai i ka Lookup_value;
• Inā heʻuʻuku ka Lookup_value ma mua o nā kumukūʻai a pau i ka Lookup_vector ,ʻo ka hana LOOKUP e hoʻihoʻi i ka hapa # N / A.

03 o 04

Hōʻike hiʻohiʻona LOOKUP

E like me kaʻikeʻia ma ke kiʻi ma luna, e hoʻohana kēiaʻano i ka Vector Form of the LOOKUP function in a formula to find the price of a Gear in the list list with the following formula:

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

No ka hoʻomaʻemaʻeʻana i ka hoʻokomoʻana i nā kumuhana o ka hana, hoʻohanaʻia ka hōʻike dialog dialog LOOKUP i kēia mau hana.

1. E kaomi i ke kelepona E2 ma ka pepa ha awina e lilo ia i ke kamera paʻa ;
2. Kaomi ma kaʻaoʻao Formulas o kahi papa inoa;
3. E koho i ka nānā a me ka huliʻana mai kahi lepikona e wehe i ka papa inoa lalo iho o ka papahana;
4. Kaomi ma LOOKUP ma ka papa inoa e hāpai i ka pahuhopu dialect arguments Select ;
5. Kaomi ma ka lookup_value, lookup_vector, koho result_vector ma ka papa inoa;
6. E kaomi iā OK e hāpai i ka pahu pahu pahu Hana Hana ;
7. Ma ka pahu kūkākūkā, e kaomi i ka laina Lookup_value ;
8. E kaomi i ka pūnaewele D2 ma ka pepa haʻawina e komo i kēlā kuhikuhi i loko o ka pahu pahu - i loko o kēia pūnaewele e kākau mākou i ka inoa inoa a mākou eʻimi nei.
9. Kaomi ma ka laina Lookup_vector i loko o ka diabole;
10. ʻO nā kikowaena D5 i D10 ma ka pepa haʻawina e komo i kēia kikowaena i ka pahu kūkākūkā - aia kēia mahele i nā inoaʻaoʻao;
11. Kaomi ma ka laina Result_vector i loko o ka pahu pahu;
12. E hōʻike i nā pūnaewele E5 i ka E10 ma ka pepa haʻawina e komo i kēia āpau ma ka pahu kūkākūkā - aia kēia me nā kumukūʻai no ka papa inoa o nā'āpana;
13. E kaomi iā OK e hoʻopiha i ka hana a hoʻopau i ka pahu pahu;
14. Loaʻa kahi hanana # N / A ma ka pūnaewele E2 no ka meaʻaʻole mākou e kākau i kahi inoa ma ka pūnaewele D2

04 o 04

Komo i loko o ka Nānā Lookup

Kaomi ma ke kelepona D2, kāpili Gear a pēhi i ka pihi komo ma kaʻaoʻao keyboard

1. Pono ke kālā $ 20.21 i loko o ke kelepona E2, no ka mea, eia ke kumukuai o kahi pahu i hoʻonohoʻia ma ka papaʻelua o ka papa heluʻikepili;
2. E ho'āʻo i ka hana ma ke kākauʻana i nā inoa'ē aʻe i loko o ka cell D2. ʻO ke kumukūʻai no kēlā me kēia māhele o ka papa inoa eʻikeʻia ma ke kelepona E2;
3. Ke pāʻaniʻoe i ka pūnaewele E2, ka hana piha
   = LOOKUP (D2, D5: D10, E5: E10) i loko o ka pae kumu ma luna aʻe o ka pepa haʻawina.