Indlela yokupakisha kahle i-parachute?
Zuza. Uhlelo 2, lubuyekeziwe.
Ake sithi sinethebula lama-oda elilandelayo:
Sidinga ukwazi, ngokwesibonelo, ukuthi yayingakanani inani le-oda lesithathu lika-Ivanov noma lapho uPetrov enza isivumelwano sakhe sesibili. Umsebenzi owakhelwe ngaphakathi we-VLOOKUP ungasesha kuphela ukwenzeka kokuqala kwesibongo kuthebula futhi ngeke usisize. Imibuzo efana nokuthi “Ubani obengumphathi wenombolo ye-oda 10256?” nayo izohlala ingaphendulwa, tk. i-VLOOKUP eyakhelwe ngaphakathi ayikwazi ukubuyisela amanani ukusuka kumakholomu ukuya kwesokunxele kwesesho.
Zombili lezi zinkinga zixazululwa ngesikhathi esisodwa - ake sibhale umsebenzi wethu ongeke ubheke owokuqala kuphela, kodwa, esimweni esijwayelekile, ukwenzeka kwe-Nth. Ngaphezu kwalokho, izokwazi ukusesha futhi ikhiqize imiphumela kunoma yimaphi amakholomu. Masiyibize, sithi, VLOOKUP2.
Vula i-Visual Basic Editor ngokucindezela i-ALT+F11 noma ngokukhetha kumenyu Isevisi – Macro – Visual Basic Editor (Amathuluzi — Macro — Visual Basic Editor), faka imojuli entsha (imenyu Faka – Imojula) bese ukopisha umbhalo walo msebenzi lapho:
Umsebenzi we-VLOOKUP2(Ithebula Njengoguquguqukayo, I-SearchColumnNum Isikhathi Eside, I-SearchValue Njengokuguquguqukayo, _ N Njengoba Mude, I-ResultColumnNum As Long) Dim i Kade, iCount Kade Khetha Ikesi UhloboIgama(Ithebula) Ikesi "Ububanzi" For i = 1 To Table.Imigqa .Bala Uma Ithebula.Amaseli(i, SearchColumnNum) =SearchValue Bese i-iCount = iCount + 1 Qeda Uma iCount = N Bese VLOOKUP2 = Ithebula.Amaseli(i, ResultColumnNum) Aphumela Ekugcineni Uma Okulandelayo Ikesi "Variant()" Ngokuba i = 1 Ukuhlehlisa(Ithebula) Uma Ithebula(i, SearchColumnNum) = SearchValue Bese iCount = iCount + 1 Uma iCount = N Bese VLOOKUP2 = Ithebula(i, ResultColumnNum) Phumela Ekugcineni Uma Okulandelayo Ngiphetha Khetha Qeda Umsebenzi
Vala i-Visual Basic Editor bese ubuyela ku-Excel.
Manje kuphelile Faka – Umsebenzi (Faka - Umsebenzi) esigabeni Ukuchazwa Komsebenzisi (Umsebenzisi Uchaziwe) ungathola umsebenzi wethu we-VLOOKUP2 futhi uwusebenzise. I-syntax yomsebenzi imi kanje:
=I-VLOOKUP2(ithebula; inombolo_yekholomu_lapho_sibheka khona; inani_lokubheka; N; inombolo_yekholomu_kusuka_kuya_kuthole_inani)
Manje ukulinganiselwa komsebenzi ojwayelekile akusona isithiyo kithi:
PS Sibonga ngokukhethekile i-The_Prist ngokwenza ngcono umsebenzi ukuze ikwazi ukusesha ezincwadini ezivaliwe.
- Ukuthola nokufaka idatha kusuka kwelinye ithebula kuye kwelinye kusetshenziswa umsebenzi we-VLOOKUP
- “I-VLOOKUP yesokunxele” isebenzisa imisebenzi ye-INDEX kanye ne-MATCH