Pezani Chidziwitso mu Deta Zapamwamba Pogwiritsa Ntchito KUCHOKERA

01 ya 01

Excel KUYENERA Kugwiritsa Ntchito Maphunziro mu Fomu Yowonjezera

Ntchito ya Excel LOOKUP ili ndi mitundu iwiri: Fomu ya Vector ndi Fomu ya Array .

Maonekedwe a ntchito YOKUKHALA ali ofanana ndi ena Excel kuyang'ana ntchito monga VLOOKUP ndi HLOOKUP kuti angagwiritsidwe ntchito kupeza kapena kuyang'ana ndondomeko zomwe zili mu tebulo deta.

Momwe zimasiyanirana ndikuti:

1. Ndi VLOOKUP ndi HLOOKUP, mungasankhe mzere kapena mzere kuti mubwezeretse chiwerengero cha deta, pomwe LOOKUP nthawizonse imabweretsanso mtengo kuchokera mumzere wotsiriza kapena mzere wotsatira .
2. Poyesera kupeza machesi a mtengo wotchulidwa - wotchedwa Lookup_value - VLOOKUP amangosaka chigawo choyamba cha deta ndi HLOOKUP mzere woyamba, pamene ntchito LOOKUP ifufuza mzere woyamba kapena chigawo malinga ndi mawonekedwe a gulu .

KUKHALA NTCHITO NDI NTCHITO YOSUNGA

Mmene mawonekedwe ake alili - kaya ndi ofanana (nambala yofanana ya mizere ndi mizere) kapena rectangle (osayenerera nambala ya zipilala ndi mizere) - zimakhudza komwe ntchito LOOKUP ikufufuza data:

• Ngati gulu liri lopangidwa mozungulira kapena ngati wamtali wamtali (wamtali kuposa wamtali), KUYANGALIRA akuwona kuti deta ikukonzedwa muzitsulo ndipo chotero kufufuza kwa machesi ku Lookup_value mu ndime yoyamba ya mndandanda.
• Ngati gulu liri lozungulira kwambiri (lalikulu kuposa lalitali), LOOKUP imaganiza kuti deta ikukonzedwa m'mizere ndipo kotero kufufuza kwa machesi ku Lookup_value mu mzere woyamba wa mndandanda.

Ntchito YOKUKHALA Syntax ndi Arguments - Fomu Yowonjezera

Mawu omasulira a Fomu ya Ntchito ya LOOKUP ndi:

= LOOKUP (Lookup_value, Array)

Kuwonetsa_kuyimira (kofunikira) - phindu lomwe ntchitoyo ikufufuzira m'ndandanda. Lookup_value ikhoza kukhala nambala, malemba, mtengo wapatali, kapena dzina kapena selo lofotokozera lomwe limatanthawuza kufunika.

Zokwanira (zofunikira) - maselo osiyanasiyana omwe ntchitoyo ikufufuza kuti mupeze lookup_value. Deta ikhoza kukhala malemba, manambala, kapena malingaliro abwino.

Mfundo:

• Kuti ntchito YOKUKHALA ikhale yoyenera, kukangana kwadongosolo kuyenera kukonzedwa mu kukwera kwadongosolo (A mpaka Z kapena yaying'ono mpaka yaikulu kwa chiwerengero)
• Ngati ntchitoyo silingapeze mndandanda weniweni wa Lookup_value, imasankha mtengo waukulu kwambiri mu Mzere umene uli wochepa kapena wofanana ndi mtengo wa Lookup_value
• Ngati Lookup_value ikusowa kapena yaying'ono kuposa zonse zomwe zili mu Array, ntchito LOOKUP idzabweretsa vuto la # N / A

Chitsanzo Pogwiritsa Ntchito Fomu Yoyang'anira

Monga momwe tawonera pa chithunzi pamwambapa, chitsanzo ichi chidzagwiritsa ntchito Fomu ya Ntchito YOKUKHALA kuti mupeze mtengo wa Whachamacallit m'ndandanda wazinthu.

Mmene mawonekedwewo aliri ndilolitali . Chifukwa chake, ntchitoyo idzabweretsa mtengo womwe uli m'ndandanda yomaliza ya mndandanda wazomwe akufufuza.

Kusankha Deta

Monga momwe tawonetsera m'makalata omwe ali pamwambapa, deta yanuyi iyenera kukonzedweratu kukwera dongosolo kuti ntchito YOKUKHALA ichite bwino.

Mukasankha deta ku Excel ndikofunikira kuti muyambe kusankha mazenera ndi mizere ya deta kuti ikonzedwe. Kawirikawiri izi zikuphatikizapo mutu wa mitu.

1. Onetsetsani maselo A4 kuti C10 mu tsamba la ntchito
2. Dinani pa tsamba la Data la menyu
3. Dinani pa mtundu Wosankha pakati pakati pa leboni kuti mutsegule mtundu wa dialog box
4. Pansi pa Phula yomwe ikulowetsa m'bokosilo mumasankha kukambirana ndi Gawo kuchokera pazomwe mungakonde
5. Ngati ndi kotheka, pansi Pakutsogolera muzisankha Makhalidwe kuchokera pazomwe mungasankhe
6. Ngati ndi kotheka, pansi pa ndondomeko ya Order yikani A mpaka Z kuchokera pazomwe mungasankhe
7. Dinani OK kuti musankhe deta ndi kutseka bokosi la dialog
8. Dongosolo la deta liyenera kufanana tsopano lomwe likuwonetsedwa pa chithunzi pamwambapa

KUYENERA KUGWIRA NTCHITO

Ngakhale kuti n'zotheka kungolemba ntchito YOSUNGA

= LOOKUP (A2, A5: C10)

mu selo lamasewera, anthu ambiri amavutika kuti agwiritse ntchito bokosi la zokambirana.

Bukhuli limakulowetsani mndandanda uliwonse pa mzere wosiyana popanda kudandaula za chigwirizano cha ntchito - monga maina osiyana ndi osiyana pakati pa zokambirana.

Masitepewa pansipa mwatsatanetsatane momwe ntchito YOKUKHALA inalowetsedwa mu selo B2 pogwiritsa ntchito bokosi.

1. Dinani pa selo B2 mu tsamba kuti mupange selo yogwira ntchito ;
2. Dinani pa tabu Zamkatimu ;
3. Sankhani Kujambula ndi Kutchulidwa kuchokera ku Riboni kuti mutsegule ntchito yolemba pansi;
4. Dinani pa LOOKUP mu mndandanda kuti mubweretse Mndandanda wazokambirana .
5. Dinani pa tsamba lookup_value, njira yowonjezera mndandanda;
6. Dinani OK kuti mukweretse bokosi lazokambirana lazokambirana.
7. Mu bokosi la bokosi, dinani pa lookup_value mzere;
8. Dinani pa selo A2 patsiku la ntchito kuti mulowetse selolo mu bokosi la dialog;
9. Dinani pa mndandanda wa mzere mu bokosi la bokosi
10. Onetsetsani maselo A5 kuti C10 mu tsamba lolemba kuti mulowetse mndandanda uwu mu bokosi la bokosi - mndandanda uwu uli ndi deta yonse kuti ifufuzidwe ndi ntchitoyo
11. Dinani OK kuti mutsirize ntchitoyi ndi kutseka bokosi la bokosi
12. Nthenda ya # N / A ikuwoneka mu selo E2 chifukwa sitiyenera kutchula dzina lachigawo mu selo D2

Kulowa Phindu Loyang'ana

1. Dinani pa selo A2, lembani Whachamacallit ndikusindikizira mu Enter key pa kambokosi;
2. Mtengo wa $ 23.56 uyenera kuwoneka mu selo B2 chifukwa ichi ndi mtengo wa Whachamacallit womwe uli mu gawo lomalizira la tebulo;
3. Yesani ntchitoyi polemba mayina ena mbali mu selo A2. Mtengo wa gawo lirilonse mndandanda udzawonekera mu selo B2;
4. Mukasindikiza pa selo E2 ntchito yonse = LOOKUP (A2, A5: C10) ikuwoneka mu barra ya fomu pamwamba pa tsamba.