ʻO Excel Two Way Lookup Ma o ka hoʻohanaʻana i VLOOKUP Part 1

Ma ka hoʻohuiʻana i kaʻoihana VLOOKUP a Excel me ka hana MATCH , hiki iā mākou ke hana i ka mea iʻikeʻia heʻano huliʻelua aʻelua paha i hiki iāʻoe ke maʻalahi i nā māheleʻelua o kaʻikepili ma loko o kahiʻikepili pūnaewele paha.

Hoʻohana maikaʻiʻia kahi hua'ōlelo huliʻelua inā makemakeʻoe eʻike a hoʻohālikelike i nā hopena no nāʻano likeʻole.

Ma ke kumu i hōʻikeʻia ma ke kiʻi ma luna, ua maʻalahi ka laweʻana i nā kikohi kiʻi no nā kuki'ē aʻe i nā mahina likeʻole ma ka loliʻana i ka inoa cookie a me ka mahina ma nā pūnaewele pololei.

01 o 06

E huli i kaʻikepili ma ka Point Intersection o kahi Lālā a me Kelena

Hoʻokuʻiʻia kēia kulekele iʻelua mau'āpana. Ma muli o nā kūkuhi i heluʻia ma kēlā me kēiaʻaoʻao e hana i ka hanana nānā lua iʻikeʻia ma ka kiʻi ma luna.

Aia ka papahana e pili ana i ka hana MATCH i loko o VLOOKUP.

ʻO ka hanaʻana i kahi hana e komo i kahi hanaʻeluaʻo ia kekahi o nā kumuhana no ka hana mua.

Ma kēia papa aʻo, e hoʻokomoʻia ka hana MATCH ma keʻano he helu helu helu helu maha no VLOOKUP.

Nā'Ikehopu Tutorial

• E komo i loko o kaʻikepili aʻo
• Ke hanaʻana i kahi Wahi i kapaʻia no ka PakuhiʻIkepili
• Ke hoʻomaka nei i ka hana VLOOKUP
• Komo i loko o ka hoʻopiʻi kūpono o ka nānā
• E komo i loko o ka Argum Argum Argum
• Ke hoʻomaka nei i ka hana MATCH Nested
• Ke hoʻoukaʻana i nā Pūnaeweleʻikepili no ka hana MATCH
• Hoʻohui i kaʻano Pelekikena a me ka Hoʻopiha i ka hana MATCH
• Hoʻopiha i ka hana VLOOKUP
• Pākuʻi i nā Kumu Huli Huli no ka Hoʻopaleʻana i ke Kauoha i Hoʻopauʻia
• Ke kāpekaʻana i ka Formula Dual Lookup Formula me ka hoʻopiha pihaʻana

02 o 06

E komo i loko o kaʻikepili aʻo

ʻO ka hana mua i loko o ka aʻoʻana, e hoʻokomo i kaʻikepili i loko o kahi hana hana Excel.

No ka hahaiʻana i nā paepae i loko o ke aʻo komo e hoʻokomo i nāʻikepili i hōʻikeʻia ma ka kiʻi i luna i loko o nā pūpili .

• E komo i ka hiku o kaʻikepili i nā pūnaewele D1 a hiki i F1
• E komo i kaʻaoʻaoʻelua i nā pūnaewele D4 i ka G8

Ua waihoʻia nā māka 2 a me 3 no ka hikiʻana i nā kulekele hulina a me keʻano nānā i hanaʻia i loko o kēia kumu aʻo.

ʻAʻole ka papahana i hoʻokomo i ka hōpili iʻikeʻia ma ke kiʻi, akā,ʻaʻole ia e hoʻololi i ka hanaʻana o ke kiko nānā.

ʻO nāʻike e pili ana i nā koho koho like i nā mea iʻikeʻia ma luna nei e loaʻa ana i kēia Basic Basic Tutorial .

Nā Kūlana Haʻawina

1. E komo i kaʻikepili e like me ka mea iʻikeʻia ma ka kiʻi ma luna i nā pūnaewele D1 a hiki i G8

03 o 06

Ke hanaʻana i kahi Wahi i kapaʻia no ka PakuhiʻIkepili

ʻO kahi laulā i kapaʻia he ala maʻalahi e nānā i kahi o nāʻikepili ma kahiʻano. Ma mua o ka paʻiʻana i nā kuhikuhi no kaʻikepili no kaʻikepili, hiki iāʻoe ke kāhua i ka inoa o ke ana wale nō.

ʻO ka lua kūpono no ka hoʻohanaʻana i ka inoa i kapaʻiaʻo keʻano o nā kikowaena pūnaewele no kēia awenaʻaʻole e loli i ka wā e paʻiʻia ke kulehana i nā pūnaewele'ē aʻe ma ka pepa haʻawina.

Nā Kūlana Haʻawina

1. E wehe i nā pūnaewele D5 i ka G8 ma ka pepa haʻawina e koho ai iā lākou
2. Kaomi ma ka pahu inoa ma luna o ka papaʻo A
3. Eʻano "papa" (no quotes) i loko o ka pahu inoa
4. E kaomi i ke pihi ENTER ma ka papa keyboard
5. Loaʻa i nā pūnaewele D5 i G8 ka inoa o ka "table". E hoʻohana mākou i ka inoa no ka pane o ka papahana VLOOKUP ma hope ma ke kumu aʻo

04 o 06

Ke weheʻana i ka pahu hōʻikeʻo VLOOKUP

ʻOiai hiki ke hana wale i kā mākou kulekele huli i loko o kahi pūnaewele i loko o ka pepa hana, he nui nā kānaka e paʻakikī i ka mālamaʻana i ka syntax pololei - no ka mea maʻamau e like me kēia e hoʻohana nei mākou i kēia kumu aʻo.

ʻO kekahi koho, ma kēia hihia, e hoʻohana i ka pahu kamaʻilio VLOOKUP. Loaʻa i nāʻoihana Excel a pau he dialogu ka mea eʻae iāʻoe e komo i kēlā me kēia o nā pane o ka hana ma kahi laina'ē aʻe.

Nā Kūlana Haʻawina

1. E kaomi i ka pūnaewele F2 o ka pepa hana - kahi e hōʻikeʻia ai nā hualoaʻa o ka hoʻopili heluʻelua
2. E kaomi i kaʻaoʻao Formulas o kahi kikokikona
3. E kaomi i ka koho Lookup & Reference ma ka pahu liʻiliʻi e wehe i ka papa inoa lalo iho o ka papahana
4. Kaomi ma VLOOKUP ma ka papa inoa e hāpai i ka pahuhopu diaka o kaʻoihana

05 o 06

Komo i loko o ka hoʻopiʻi kūpono o ka nānā

Ma keʻano maʻamau, ua pili ka helu nānā i kahi kahuaʻikepili i ka kolamu mua o ka papa heluʻikepili.

I loko o ko mākou hiʻohiʻona, e pili ana ka manaʻo nānā i kaʻano o ka kuke e makemake mākou eʻike i kaʻike e pili ana.

ʻO nāʻano o nāʻikepili o kaʻikepili no ka helu huli ke:

• ʻikeʻikepili
• kahi helu kūpono (TRUE aiʻole FALSE wale nō)
• he helu
• ke kuhi pūnaewele i kahi waiwai ma ka pepa haʻawina

Ma kēia hiʻohiʻona, e komo mākou i kahi kuhikuhi pūnaewele kahi e loaʻa ai ka inoa o ke kuki - kelepona D2.

Nā Kūlana Haʻawina

1. Kaomi ma ka laina lookup_value ma ka pahu dialog
2. Kaomi ma ke kelepona D2 e ​​hoʻonui i kēia kuhi pūnaewele i ka laina lookup_value . ʻO kēia ke kelepona kahi e kāomi ai mākou i ka inoa cookie e pili ana i ka mea eʻimi nei mākou i kaʻike

06 o 06

E komo i loko o ka Argum Argum Argum

ʻO ka papa o ka papaʻaina ka papa o nāʻikepili i nānāʻia e ka'ōnaehana huli e loaʻa ai kaʻike a mākou e makemake ai.

ʻO ka papa o ka papa e pono e komo i loko oʻelua mau koluma o kaʻikepili .

• aia ka papa mua i ka manaʻo helu koho (kahi mua i ka papa kuhikuhi)
• ka lua, a me kekahi mau pou'ē aʻe, e huliʻia e ke kumu huli e huli i kaʻike a mākou i hōʻike ai.

Pono e hoʻokomo i ka pane pane i hoʻonohonohoʻia e like me ka laulā e pili ana i nā kikowaena pūnaewele no ka papaʻikepili aiʻole he inoa inoa .

No kēia hiʻohiʻona, e hoʻohana mākou i ka inoa inoa i hanaʻia ma kaʻaoʻao 3 o kēia aʻo.

Nā Kūlana Haʻawina

1. Kaomi ma ka laina papaʻaina ma ka dialog
2. Eʻano "papa" (no quotes) e komo i ka inoa inoa no kēia manaʻo
3. E haʻalele i ka pahu hōʻikeʻo VLOOKUP no kaʻaoʻao aʻe o ke kumu aʻo

E hoʻomau i ka Māhele 2 >>