Nzira yekurongedza sei parachute?
Benefit. Edition 2, yakadzokororwa.
Ngatitii tine tafura inotevera yemirairo:
Isu tinofanirwa kuziva, semuenzaniso, yaive mari yeiyi yechitatu yekuraira kana Petrov paakaita chibvumirano chake chechipiri. Iyo yakavakirwa-mukati VLOOKUP basa rinogona chete kutsvaga kwekutanga kuitika kwezita rekupedzisira mutafura uye hazvizotibatsira. Mibvunzo yakaita senge "Ndiani aive maneja weodha nhamba 10256?" icharambawo isina kupindurwa, tk. iyo yakavakirwa-mukati VLOOKUP haikwanise kudzosa kukosha kubva kumakoramu kuruboshwe rwekutsvaga.
Matambudziko ese ari maviri anogadziriswa mune imwe yakawa swoop - ngatinyorei yedu basa iro risingatarise rekutanga chete, asi, mune yakajairika, yeNth kuitika. Uyezve, ichakwanisa kutsvaga uye kuburitsa mhedzisiro mune chero makoramu. Ngatiidaidze, toti, VLOOKUP2.
Vhura iyo Visual Basic Mharidzo nekudzvanya ALT+F11 kana nekusarudza kubva kumenyu Basa - Macro - Visual Basic Edhita (Zvishandiso - Macro - Visual Basic Edhita), isa module nyowani (menu Pinza – Module) uye kopira zvinyorwa zvebasa iri ipapo:
Basa VLOOKUP2(Table As Variant, SearchColumnNum As Long, SearchValue As Variant, _ N As Long, ResultColumnNum As Long) Dim i Nenguva Yakareba, iCount As Long Sarudza Case TypeName(Table) Case "Range" For i = 1 To Table.Rows. .Count Kana Table.Cells(i, SearchColumnNum) = SearchValue Then iCount = iCount + 1 End Kana iCount = N Zvadaro VLOOKUP2 = Table.Masero(i, ResultColumnNum) Buda Kumagumo Kana Inotevera iCase "Variant()" For i = 1 Ku UBound(Table) Kana Tafura(i, SearchColumnNum) = SearchValue Then iCount = iCount + 1 Kana iCount = N Ipapo VLOOKUP2 = Tafura(i, ResultColumnNum) Buda Kumagumo Kana Ikazopera Ndapedza Sarudza Kupera Basa
Vhara iyo Visual Basic Mharidzo uye dzokera kuExcel.
Zvino kuburikidza Pinza – Basa (Isa - Basa) muchikwata Mushandisi Anotsanangurwa (Mushandisi Anotsanangurwa) unogona kuwana yedu VLOOKUP2 basa uye rishandise. Basa re syntax rakaita seizvi:
=VLOOKUP2(tafura; nhamba_yekoramu_kwati_tinotsvaga; tsvaga_kukosha; N; nhamba_yekororamu_kubva_kusvika_kuwana_kukosha)
Ikozvino izvo zvinogumira zveyakajairwa basa hazvisi chipinganidzo kwatiri:
PS Kutenda kwakakosha kuThe_Prist nekuvandudza basa kuti rikwanise kutsvaga mumabhuku akavharwa.
- Kutsvaga uye kutsiva data kubva kune imwe tafura kuenda kune imwe uchishandisa iyo VLOOKUP basa
- "Kuruboshwe VLOOKUP" uchishandisa INDEX uye MATCH mabasa