Momwe munganyamulire parachute moyenera?
Pindulani. Edition 2, yosinthidwa.
Tiyerekeze kuti tili ndi madongosolo awa:
Tiyenera kudziwa, mwachitsanzo, kuchuluka kwa lamulo lachitatu la Ivanov kapena pamene Petrov adachita mgwirizano wake wachiwiri. Ntchito ya VLOOKUP yomangidwa imatha kungofufuza dzina lomaliza patebulo ndipo silingatithandizire. Mafunso ngati "Kodi woyang'anira nambala 10256 anali ndani?" nawonso adzakhala osayankhidwa, tk. VLOOKUP yomwe idamangidwayo siyitha kubweza makonda kuchokera kumizere kupita kumanzere kwakusaka.
Mavuto onsewa amathetsedwa m'njira imodzi - tiyeni tilembe ntchito zathu zomwe sizidzayang'ana koyamba, koma, makamaka, pazochitika za Nth. Kuphatikiza apo, idzatha kusaka ndi kutulutsa zotsatira muzambiri zilizonse. Tiyeni titchule, titi, VLOOKUP2.
Tsegulani Visual Basic Editor mwa kukanikiza ALT+F11 kapena posankha kuchokera pa menyu Utumiki - Macro - Visual Basic Editor (Zida - Macro - Visual Basic Editor), ikani gawo latsopano (menu Ikani - Module) ndikukopera zolemba za ntchitoyi pamenepo:
Ntchito VLOOKUP2(Table As Variant, SearchColumnNum Utali, SearchValue As Variant, _ N Kutalika, ResultColumnNum As Utali) Dim i Potalikirapo, iCount Monga Nthawi Yosankha TypeName(Table) Case "Range" For i = 1 to Table.Rows .Werengerani Ngati Table.Cells(i, SearchColumnNum) = SearchValue Ndiye iCount = iCount + 1 Mapeto Ngati iCount = N Kenako VLOOKUP2 = Table.Maselo(i, ResultColumnNum) Tulukani Kumapeto Ngati Kenako I Muse "Variant()" Kwa i = 1 Ku UBound(Table) Ngati Table(i, SearchColumnNum) = SearchValue Ndiye iCount = iCount + 1 Ngati iCount = N Ndiye VLOOKUP2 = Table(i, ResultColumnNum) Tulukani Pamapeto Ngati Kenako Ndimaliza Sankhani Mapeto Ntchito
Tsekani Visual Basic Editor ndikubwerera ku Excel.
Tsopano kudutsa Insert - Ntchito (Ikani - Ntchito) mu gulu Kumasulira Womasulira (Kutanthauzira Wogwiritsa) mutha kupeza ntchito yathu ya VLOOKUP2 ndikuigwiritsa ntchito. Syntax ya ntchito ndi motere:
=VLOOKUP2(tebulo; nambala_ya_gawo_komwe_tikuyang'ana; mtengo_woyang'ana; N; chiwerengero_cha_gawo_kuchokera_kufikira_kupeza_mtengo)
Tsopano zofooka za ntchito yokhazikika sizolephereka kwa ife:
PS Tithokoze mwapadera The_Prist pokonza ntchitoyi kuti izitha kusaka m'mabuku otsekedwa.
- Kupeza ndikusintha deta kuchokera patebulo limodzi kupita kwina pogwiritsa ntchito ntchito ya VLOOKUP
- "VLOOKUP yakumanzere" pogwiritsa ntchito INDEX ndi MATCH