Yadda ake yin vidiyo a cikin Excel? Taimakawa kallon kallo

Kwatanta jerin a Excel tare da cikakkiyar hangen nesa

Lokacin amfani da kallo na jerin abubuwa daga tushe daban-daban, watakila zaka iya ƙare rashin kasancewa daidai da dabi'u. Wannan jagorar akan hangen nesa na taimakawa mai kyau zai nuna muku yadda ake magance matsaloli gama gari akan me yasa kallon kallo bashi aiki kamar:

• dubawa cikin kyakkyawan aiki,
• kallon kallo baya aiki akan rubutu,
• duba daban daban,
• kyau dubawa ba aiki a kan rubutu.

Vlookup baya aiki akan rubutu a cikin Excel

Misali na yau da kullun: SAP cirewa idan aka kwatanta da fayil ɗin rubutu na gida, jerin Excel idan aka kwatanta da cirewar SAP, jerin Excel idan aka kwatanta da jerin rubutu, ...

Yin amfani da tushe daban-daban yawanci shine dalilin da yasa kallon-kallo a cikin Excel ba ya aiki a kan rubutu, saboda nau'ikan daban-daban da aka yi amfani dasu don kwatanta jeri a cikin Excel, saboda haka yana haifar da sakamako ba daidai ba Maganin shine farawa ta hanyar sanya duk bayanan ku a cikin tsari mai kama.

Tsinkaye dabaru daban daban

Dubi misali a sama. Jerin farko a Matsayi na Excel, jeri na biyu azaman fayil rubutu. Lokacin kwafin dabi'u daga fayil ɗin rubutu a cikin Excel, sakamakon ba daidai bane saboda ana amfani da Vlookup don kwatanta jerin abubuwa a Excel tare da tsaran tsari:

• darajan 05678 ya kasance a cikin duka lambobi guda biyu, amma kallon kallo bai same shi ba,
• ƙimar 19459 ba ta kasance a cikin fayil ɗin rubutu ba, amma hangen nesa ya same shi.

Dubi misalin yadda ake yin vidiyo a cikin Excel.

A gefen hagu, an kwafa abubuwan dabi'u a kai tsaye a cikin Excel don kwatanta jeri biyu tsakanin juna tare da kallon kallo.

Kasance mai kyau Pro: Kasance da karatunmu!

Daukaka kwarewarku daga novice ga gwarzo tare da muxin muxinmu na 365, wanda aka tsara don sanya ku ƙwarewa a cikin 'yan zaman a cikin' yan zaman.

Rijista a nan

Daga hannun dama, an kwafa dabi'u a Excel biyo bayan wannan hanyar, kuma yana ba da sakamako daidai.

Excel taimako vidiyo don magance fitowar tsari daban-daban

A takaice, don sanin yanayin hangen nesa, kawai a bi wadannan matakan:

• Ka kirkiri sabbin makoma mai kyau na rubutu kamar rubutu (Fig03),
• Kwafa bayanai daga fayil na 1st a cikin edita na rubutu, misali Notepad ko Notepad ++ (Fig04, Fig05),
• Manna bayanai daga fayil na 1st a cikin ginshiƙan rubutu masu kyau na Excel (Fig06, Fig07),
• Kwafa bayanai daga fayil na 2 a cikin edita na rubutu, misali Notepad ko Notepad ++,
• Manna bayanai daga fayil na 2 a cikin ginshiƙan rubutu na Excel (Fig08),
• Aiwatar da kallo - da voilà! (Fig09, Fig03).

Kwatanta jerin a Excel tare da cikakkiyar hangen nesa

Don yin cikakken lissafin kwatancen, bi waɗannan matakan Excel na duba hanyoyin gani:

• suna da lissafin dabi'u masu shirye,
• Tsarin halitta zuwa rubutun ta hanyar zakuɗa dabi'u a editan rubutu kuma dawo a Excel,
• zaɓi tantanin halitta kusa da darajar farko don bincika,
• shigar da samfurin = vlookup (darajar neman, [jerin abubuwan kirki don bincika], 1,0),
• Yi amfani da vlookup a kan dukan jerin da aka ƙaddamar a matsayin rubutu.

Wannan zai tabbatar da cewa duk abubuwan kirki sun samo asali ta hanyar Velup na Excel, don haka idan ba haka ba zai daidaita dabi'un da tsarin daban ba.

Tambayoyi Akai-Akai

Ta yaya zan iya yin taka tsi game da fice?

Don yin VLOLUP a Excel, shigar da tsari = VLOUUP_Value, Table_indir, Col_dedx_num, [kewayon_dedx_num. Sauya Duba_Value tare da darajar da kake son bincika, Table_indEx_num tare da lambar shafi da kake son dawowa, kuma [kewayon_yar_num) tare da kalmar gaskiya ko gaskiya don daidaitaccen wasa .

Wadanne matakai ake buƙata don yin aikin kallo na Velup a Forevel a cikin Forevoren suna neman daidaita bayanai a fadin zanen gado daban-daban?

Don amfani da VILOLOUP, shigar da tsari `= VLOLOUP (Table_aray, Col_denex_num, [Scarray, Col_denex_num, [Scarray, Col_dedx_num Sauya 'Duba_velue` Tare da darajar da kuke nema,' Tebur_arina ko gaskiya don kimanin wasa.

Cikakken 2019 Excel ga Masu farawa a bidiyo