Contents
A cikin wannan misalin, zaku koyi duk game da ayyukan Excel don aiki tare da hanyoyin haɗin gwiwa da tsararru, kamar su VPR, GPR, MORE BAYYANA, INDEX и Sakamakon.
VPR
aiki VPR (VLOOKUP) yana duba ƙimar a ginshiƙin hagu na tebur kuma ya dawo da ƙimar tantanin halitta a cikin ƙayyadadden ginshiƙi na jere ɗaya.
- Saka aiki VPR:
=ВПР(A2;$E$4:$G$7;3;ЛОЖЬ)=VLOOKUP(A2,$E$4:$G$7,3,FALSE)Ƙarin bayani:
- aiki VPR neman daraja ID (104) a cikin ginshiƙin hagu na kewayon $E$4:$G$7 kuma ya dawo da ƙimar daga shafi na uku na jere ɗaya (tunda hujja ta uku na aikin shine 3).
- Hujja ta hudu na aikin shine KARYA (KARYA) - wannan yana nufin cewa ko dai za a sami ainihin wasa, ko kuma za a nuna saƙon kuskure # N / A (#N/A).
- Jawo linzamin kwamfuta don kwafe aiki VPR daga cell B2 saukar da shafi zuwa tantanin halitta B11.
Bayani: Lokacin da muka kwafi aiki VPR ƙasa, cikakkiyar mahada $E$4:$G$7 ya kasance baya canzawa, yayin da ma'anar dangi A2 canje-canje ga A3, A4, A5 da sauransu.
Bayani: Lokacin da muka kwafi aiki VPR ƙasa, cikakkiyar mahada $E$4:$G$7 ya kasance baya canzawa, yayin da ma'anar dangi A2 canje-canje ga A3, A4, A5 da sauransu.GPR
Aikin yana aiki a irin wannan hanya. GPR (HLOOKUP):
MORE BAYYANA
aiki MORE BAYYANA (MATCH) yana dawo da matsayin ƙimar da aka nema a cikin kewayon da aka bayar:
Ƙarin bayani:
- Kalmar Yellow ya mamaye matsayi na uku a cikin kewayon E4: ku 7.
- Hujjar aiki ta uku na zaɓi ne. Idan kun shigar da ƙimar wannan hujja 0 (sifili), sa'an nan aikin zai dawo da matsayin kashi wanda yayi daidai da ƙimar da aka nema (A2). Idan ba'a samo ainihin wasa ba, aikin zai dawo da kuskure. # N / A (#N/A).
INDEX
aiki INDEX (INDEX) yana dawo da ƙimar da aka bayar daga kewayo mai girma biyu ko mai girma ɗaya.
Bayani: Ma'ana 92 yana a mahadar layin 3 da shafi 2 a cikin kewayon E4:F7.
Bayani: Ma'ana 97 is located 3 wuri a cikin kewayon E4: ku 7.
Sakamakon
aiki Sakamakon (ZABI) yana zaɓar ƙima daga jeri a lambar matsayi da aka bayar.
Bayani: Kalma Boat yana cikin matsayi 3.