Me pehea te takai tika i te parachute?
Painga. Putanga 2, kua whakahoutia.
Me kii kei a maatau te rarangi ota e whai ake nei:
Me mohio tatou, hei tauira, he aha te nui o te ota tuatoru a Ivanov, i te wa ranei i mahia ai e Petrov tana mahi tuarua. Ka taea e te mahi VLOOKUP kua hangaia te rapu i te putanga tuatahi o te ingoa whakamutunga i roto i te ripanga, kaore e awhina i a maatau. Ko nga patai penei "Ko wai te kaiwhakahaere o te ota nama 10256?" ka noho kore whakautu, tk. kaore e taea e te VLOOKUP kua hangaia te whakahoki i nga uara mai i nga pou ki te taha maui o te rapu.
Ko enei raruraru e rua ka whakaotihia i te wa kotahi - me tuhi ta tatou ake mahi e kore e titiro mo te tuatahi anake, engari, i roto i te keehi whanui, mo te tupunga Nth. I tua atu, ka taea e ia te rapu me te whakaputa hua i roto i nga pou katoa. Karangatia, me kii, VLOOKUP2.
Whakatuwheratia te Kaiwhakatika Visual Basic ma te pehi i te ALT+F11 ma te kowhiri ranei mai i te tahua Ratonga – Tonotono – Kaiwhakatika Visual Basic (Utauta — Tonotono — Etita Kaupapa Ataata), kōkuhu kōwae hōu (tahua Kōkuhu – Kōwae) ka kape i te tuhinga o tenei mahi ki reira:
Taumahi VLOOKUP2(Ripanga Hei Rerekē, RapuColumnNum Kia Roa, RapuWalue Hei Rerekē, _ N I te Roa, ResultColumnNum Kia Roa) Ataahua i te Roa, iCount I te Roa Tohua Momo Momo(Ripanga) Take "Awhe" Mo i = 1 Ki te Ripanga.Rarangi. .Tauhia Mēnā Ripanga.Cells(i, RapuColumnNum) = RapuColumnNum) Na iCount = iCount + 1 Whakamutunga Ki te iCount = N Na VLOOKUP2 = Ripanga.Cells(i, ResultColumnNum) Puta Mo te Whakamutunga Ki te Panuku i te "Tauke()" Mo te i = 1 Ki te UBound(Ripanga) Mēnā Ripanga(i, RapuColumnNum) = RapuWalue Na iCount = iCount + 1 Mēnā iCount = N Na VLOOKUP2 = Ripanga(i, ResultColumnNum) Puta Mo te Whakamutunga Ki te Panuku i Whakamutunga Tohua Mahi Whakamutunga
Katia te Kaiwhakatika Visual Basic ka hoki ki Excel.
Akuanei Kōkuhu – Mahi (Kōkuhu — Taumahi) i roto i te kāwai Kua tautuhia te Kaiwhakamahi (Tautuhi Kaiwhakamahi) ka kitea e koe to maatau mahi VLOOKUP2 me te whakamahi. Ko te wetereo mahi e whai ake nei:
=VLOOKUP2(ripanga; tau_o_tīwae_ko_e rapua e matou; rapu_uara; N; tau_o_tīwae_mai_ki_whiwhi_uara)
Inaianei ko nga here o te mahi paerewa ehara i te aukati ki a maatau:
PS He mihi nui ki a The_Prist mo te whakapai ake i te mahi kia taea ai te rapu i roto i nga pukapuka kati.
- Te rapu me te whakakapi i nga raraunga mai i tetahi ripanga ki tetahi atu ma te whakamahi i te mahi VLOOKUP
- "VLOOKUP maui" ma te whakamahi i nga mahi INDEX me MATCH