tirotiro
I tenei tauira, ka ako koe mo nga mahi Excel mo te mahi me nga hononga me nga raupapa, penei VPR, GPR, ATU KAUPAPA, Index и Tuhinga.
VPR
taumahi VPR (VLOOKUP) titiro ake i te uara i te taha maui o te poupou o te ripanga ka whakahoki i te uara o te pūtau i roto i te tīwae tauwhāiti o te rarangi kotahi.
- Te whakauru mahi VPR:
=ВПР(A2;$E$4:$G$7;3;ЛОЖЬ)
=VLOOKUP(A2,$E$4:$G$7,3,FALSE)
Whakamārama:
- taumahi VPR e rapu ana i te uara ID (104) kei te taha maui o te awhe $E$4:$G$7 me te whakahoki mai i te uara mai i te pou tuatoru o te rarangi kotahi (i te mea ko te tohenga tuatoru o te mahi he 3).
- Ko te tohenga tuawha o te mahi ko teka (HAKA) – ko te tikanga ka kitea he taurite tika, ka whakaatuhia he karere hapa # N / A (#N/A).
- Tōia kiore ki te mahi tārua VPR mai i te pūtau B2 ki raro te pou ki te pūtau B11.Whakamaramatanga: Ina kapea he mahi VPR iho, hono tino $E$4:$G$7 kare tonu e rereke, ko te tohutoro whanaunga A2 huringa ki A3, A4, A5 a na i runga i.
GPR
He rite tonu te mahi a te mahi. GPR (HLOOKUP):
ATU KAUPAPA
taumahi ATU KAUPAPA (MATCH) ka whakahoki i te tuunga o te uara rapu i roto i te awhe kua homai:
Whakamārama:
- kupu Kōwhai ka noho ki te turanga tuatoru i te awhe E4:E7.
- Ko te tohenga mahi tuatoru he mea whiriwhiri. Mena ka whakauruhia e koe he uara mo tenei tohenga 0 (kore), ka whakahoki te mahi i te tuunga o te huānga e rite ana ki te uara rapu (A2). Ki te kore e kitea he taurite tika, ka whakahoki te mahi he hapa. # N / A (#N/A).
Index
taumahi Index (INDEX) ka whakahoki i tetahi uara mai i te awhe ahu-rua, ahu-tahi ranei.
Whakamarama: Te tikanga 92 kei te wahanga o te raina 3 me te poupou 2 i roto i te awhe E4:F7.
Whakamarama: Te tikanga 97 kei hea 3 tuu i roto i te awhe E4:E7.
Tuhinga
taumahi Tuhinga (KŌWHIWHI) ka kōwhiri i tētahi uara mai i te rārangi i te tau tūnga kua homai.
Whakamarama: Kupu Pate kei te turanga 3.