01 a 03
Pezani Phindu la Phindu ndi VLOOKUP
Momwe ntchito ya VLOOKUP imagwirira ntchito
Ntchito ya VLOOKUP ya Google Spreadsheets, yomwe imayimira kuwonekera , ingagwiritsidwe ntchito kuyang'ana zenizeni zomwe zili mu tebulo la deta kapena deta.
- Mauthenga pa mauthenga olakwika a VLOOKUP angapezeke patsamba 3
VLOOKUP kawirikawiri amabwezeretsa dera limodzi la deta monga momwe linayambira. Momwe izo zimachitira izi ndi:
- Inu mumapatsa dzina kapena kusaka_kuthandizira komwe kumauza VLOOKUP mzere kapena fayilo la tebulo la deta kuti muyang'ane deta yomwe mukufuna
- Inu mumapereka chiwerengero cha mndandanda - wodziwika ngati ndondomeko - ya deta yomwe mukufuna
- Ntchitoyo imayang'ana kufufuza_maiwo mu ndime yoyamba ya tebulo la deta
- VLOOKUP ndiye amafufuza ndi kubwezeretsa zomwe mukuzifuna kuchokera kumunda wina wa zolemba zomwezo pogwiritsa ntchito nambala ya ndondomeko yomwe ilipo
Kupeza machesi ofanana ndi VLOOKUP
Kawirikawiri, VLOOKUP amayesa kupeza mndandanda weniweni wa_sakafuna_sakawonetsedwe . Ngati mwatsatanetsatane simungapezeke, VLOOKUP angapeze mzere woyenera.
- Mgwirizano woyenerera ndi mzere wapafupi ndi kukula kwa_kufuna kwanu komwe kuli kochepa kapena kochepa.
- Mafupi oyandikana amapezeka poika ntchitoyo ndi_tsutsano yowonjezera ku TRUE.
Kusankha Data Choyamba
Ngakhale sizinali zoyenera nthawi zonse, ndibwino kuti muyambe kuyang'ana deta yomwe VLOOKUP ikuyang'ana mukukwera mwadongosolo pogwiritsa ntchito chigawo choyamba cha mndandanda wa fungulo.
Ngati deta isasankhidwe, VLOOKUP ikhoza kubwezera zotsatira zosalondola.
VLOOKUP Funsani Chitsanzo
Chitsanzo mu chithunzi pamwambapa chikugwiritsa ntchito njira yotsatirayi yomwe ili ndi ntchito ya VLOOKUP kuti ipeze kuchepetsa kwa kuchuluka kwa katundu wogula.
= VLOOKUP (A2, A5: B8,2, OONA)
Ngakhale kuti ndondomeko yapamwambayi ingangosindikizidwa mu selo lamasewera, njira ina, monga yogwiritsira ntchito ndi ndondomeko zotsatirazi, ndiyo kugwiritsa ntchito bokosi la Google Spreadsheets lopangira malemba kuti mulowe muyeso.
Kulowa ntchito ya VLOOKUP
Njira zothandizira ntchito ya VLOOKUP yomwe ikuwonetsedwa m'chithunzi pamwamba pa selo B2 ndi:
- Dinani pa selo B2 kuti mupange selo yogwira ntchito - izi ndi zomwe zotsatira za ntchito ya VLOOKUP zidzawonetsedwa
- Lembani chizindikiro chofanana (=) chotsatira dzina la vlookup
- Pamene mukuyimira, bokosi lopangira mothandizidwa limapezeka ndi maina ndi ma syntax a ntchito zomwe zimayamba ndi kalata V
- Pamene dzina lakuti VLOOKUP likupezeka m'bokosilo, dinani pa dzina ndi phokoso la mouse kuti mulowetse dzina la ntchito ndi kutsegula makina ozungulira mu selo B2
Kulowa Magulu a Ntchito
- Zomwe mwatsatanetsatane za mawu a VLOOKUP ndi zifukwa zingapezeke pa tsamba 2
- Monga mu Excel, chiwerengero chimayikidwa pakati pa zokhudzana ndi ntchitoyo kuti azikhala olekanitsa.
Zolinga za ntchito ya VLOOKUP imalowa pambuyo pa bolodi lozungulira lonse mu selo B2.
- Dinani pa selo A2 patsiku la ntchito kuti mulowetse seweroli ngati ndemanga yowusaka_mavuto
- Pambuyo powerenga selo, tanizani comma ( , ) kuti mukhale olekanitsa pakati pa zotsutsana
- Onetsetsani maselo A5 kuti B8 muwunikirayi kuti mulowetse maumboni awa ngati ndemanga yosiyana - mitu ya tebulo sichiphatikizidwe
- Pambuyo pa selo yowonjezera, yesani mtundu wina
- Lembani 2 potsatira chiwerengero chotsatira ndondomeko ya ndondomeko chifukwa chiwerengero cha malingaliro ali mu ndondomeko 2 ya mkangano wosiyanasiyana
- Pambuyo pa nambala 2, lembani comma ina
- Onetsetsani maselo B3 ndi B4 pa tsamba kuti mulowetse maumboni awa ngati mpikisano wa tchuthi
- Lembani mawu Pambuyo pa comma monga momwe_kutsutsana kovomerezeka
- Dinani pakiyi ya Kulowa pa kibokosilo kuti mulowetsekali kozungulira " ) " mutatha kukangana komaliza ndi kukwaniritsa ntchitoyo
- Yankho la 2.5% - chiŵerengero cha kuchepa kwa kuchuluka kwagulidwa - chiyenera kuoneka mu selo B2 la pepala la ntchito
- Mukasindikiza pa selo B2, ntchito yonse = VLOOKUP (A2, A4: B8, 2, Zoona) ikuwonekera pa bar lamuzula pamwamba pa tsamba
Chifukwa chiyani VLOOKUP Anabweretsanso 2.5% monga Chotsatira
- Mu chitsanzo, chilembo cha Quantity sichikhala ndi mndandanda weniweni wamtengo wapatali_wowonjezera wa 23.
- Popeza kuti_tsutsano yotsatiridwa yakhazikitsidwa kuti YOKHALA, VLOOKUP idzapeza machesi ofanana ndi chiyero_funafuna .
- Phindu lapafupi lomwe liri laling'ono kwambiri kuposa chifufuzo_chiyero chachinsinsi cha 23 ndi 21.
- VLOOKUP, chotero, amafufuza peresenti yochepa pa mzere wokhala ndi 21, ndipo, motero, amabwezera mtengo wotsika wa 2.5%.
02 a 03
Google Spreadsheets Syntax ndi Arguments Funso la VLOOKUP
Syntax ndi Maganizo a Ntchito ya VLOOKUP
Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .
Chidule cha ntchito ya VLOOKUP ndi:
= VLOOKUP (search_key, range, index, is_sorted)
Kusaka_kufuna - (kofunika) mtengo wofufuzira - monga kuchuluka kugulitsidwa pa chithunzi pamwambapa
zosiyana - (zofunikira) chiwerengero cha mizere ndi mizere yomwe VLOOKUP ayenera kufufuza
- ndondomeko yoyamba mumtunduwu kawirikawiri ili ndi_funafuna
ndondomeko - (yofunika) chiwerengero cha chiwerengero cha mtengo umene mukufuna kuti mupeze
- kuwerengera kumayambira ndi kufufuza_mphindi yachinsinsi ngati khola 1
- ngati ndondomeko yaikidwa ku chiwerengero chachikulu kuposa chiwerengero cha zipilala zosankhidwa mu #REF! Cholakwika chimabweretsedwa ndi ntchito
ndi_notchulidwa - (zosankha) zikuwonetsa ngati ayi kapena ayendetsedwe mu kukwera kolandila pogwiritsa ntchito ndime yoyamba yamtundu wa fungulo
- chiwerengero cha Boolean - ZOONA kapena ZONSE ndizovomerezeka zokha
- ngati atayikidwa ku TRUE kapena atasiya ndipo chigawo choyamba cha mndandanda sichikusankhidwa kukwera, dongosolo lolakwika likhoza kuchitika
- ngati simulandire, mtengowo wasankhidwa kukhala WOYERA mwachindunji
- ngati atayikidwa ku TRUE kapena osasintha komanso mndandanda weniweni wa kufufuza_komwe sichipezeka, machesi apamfupi omwe ali ochepa kapena kukula amagwiritsidwa ntchito ngati_sakafuna_komwe.
- ngati atayikidwa ku FALSE, VLOOKUP yekha amavomereza masewera enieni a kufufuza_kufuna. Ngati pali maulendo angapo ofanana, mtengo woyamba woyanjanako umabweretsedwa
- ngati atayikidwa ku FALSE, ndipo palibe mtengo wofanana wa kufufuza_kupezeka kuti # N / A yolakwika ikubwezedwa ndi ntchito
03 a 03
VLOOKUP Zolakwa Mauthenga
VLOOKUP Zolakwa Mauthenga
Mauthenga olakwika otsatirawa akugwirizana ndi VLOOKUP.
N # N / A ("mtengo sulipo") cholakwika chikuwonetsedwa ngati:
- Kufufuza_kuthandizira sikupezeka m'ndandanda yoyamba ya mkangano wosiyana
- Mtsutso wosiyana ndi wolondola. Mwachitsanzo, kukangana kungaphatikizepo zipilala zopanda kanthu kumbali ya kumanzere
- Icho_chigwirizano chotsatiridwa chaikidwa ku FALSE ndipo masewera enieni a kutsutsana_kutsutsana kowoneka sungapezeke mu gawo loyamba la mndandanda
- Mndandanda_ndondomeko yotsatiridwa imayikidwa ku TRUE ndipo makhalidwe onse mu gawo loyambirira lazitali ndi lalikulu kuposa kufufuza_komwe
A #REF! ("kutchula zochokera kutali") vuto likuwonetsedwa ngati:
- Mndandanda wa ndondomeko ndi wamkulu kuposa chiwerengero cha zikhomodzinso pakutsutsana kwakukulu