Maitiro ekuita Vlookup muGoogle Sheets?

Chii chinonzi Vlookup Google Sheets

Kuita  Google Sheet Vlookup   is very similar to how to do vlookup in Excel, by using a single function to search for a string in a list of values, and returning a specific column on the same line as the value found.

Iro basa Vlookup, zvinoreva kuti rakatarisana nekutarisa, richatarisa runyorwa rudungwe rwe data, uye, parinowana mutengo une wakapihwa kukosha, rinodzosera kukosha rakachengetwa muchitokisi chakakumbirwa mutsara unoenderana unoenderana neGoogle Sheet Vlookup kukosha.

Kutanga pane zvese, kuti uite Vlookup Google Sheets, iwe unofanirwa kutanga uchitanga neGoogle Sheet iripo ine runyorwa rwe data.

Maitiro ekuita Google Sheet Vlookup

Kana uchiita Google Sheet Vlookup, zvinokwanisika kutsvaga mutengo unotevera sero inofanana neyewakapihwa kukosha, pamutsetse mumwe chete.

Semuenzaniso, mune yepamusoro muenzaniso, tichishandisa Vlookup muGoogle Sheets, isu tichagona kuwana kukosha kune imwe nyika yakapihwa, asi isu hatizokwanise kuwana kuti ndeipi nyika inoenderana neicho kukosha - izvi zvinodaro nekuti Vlookup nekutsvaga mune yekutanga imwe kukosha kweimwe kukosha, uye dzorera iyo kukosha mumutsara mumwe mune imwewo kamu, sekureva kwazvataurwa.

Kugadzira yekutsvaga Vlookup muGoogle Sheets

Kutanga muchitokisi nekunyora pazasi formula, uye  Google Sheets   Vlookup ichango batsira kupedzisa sero formula, uye ratidza rubatsiro nerwese ruzivo rwekuti ungashandise sei basa racho.

Pinda tambo kutsvaga mune imwe rondedzero yetsika, sarudza rondedzero yeyetsika inopinda mukati mayo mareferensi, kana kuisarudzika uchishandisa mbeva: tanga pakukosha kwepamusoro peiyo rondedzero yekutsvaga, uye pedza pane kukosha kwepazasi rondedzero tsika dzekudzoka.

Ita shuwa yekutarisa huwandu hwekolamu inoparadzanisa iyo yekutsvaga uye iyo yekudzoka ikhamu: ichave iri iyo nhamba yekupinda muVlookup  Google Sheets   seinodhura index.

VLOOKUP(search_key, range, index, [is_sorted])

Imwe mukana ndeyekuita yakasimba  Google Sheet Vlookup   nekupinda yekutsvaga kiyi rezero kune imwe foni muGoogle Sheet, pane kunyora kukosha kwakati.

VLOOKUP(search_key, range, index, [is_sorted])

Iva excel Pro: Joinha kosi yedu!

Simudza hunyanzvi hwako kubva kuLovice kuenda kuHamba NeGamba Pedu 365 Basics Course, rakagadzirirwa kukuita iwe nyanzvi mune zvikamu zvishoma.

Nyoresa pano

Kana iwe ukachinja kukosha muchitokisi chinotaurwa muchiitiko chekutsvaga, iyo Vlookup  Google Sheets   mhedzisiro ichagadziriswa zvoga maererano.

Google Sheets Vlookup ruzivo rwekubatsira

Google Sheets Vlookup inopa zvinotevera zvinotevera:

Pfupiso: Kutarisisa. Inotsvaga pasi yeyamu yekutanga yedanga reiyi kiyi uye inodzosera kukosha kweiyo sero yakatarwa mumutsara wakawanikwa.

search_key: Iko kukosha kwekutsvaga. Semuenzaniso, '42', 'Katsi' kana 'I24'.

Range: Rudzi rwekufunga nezvekutsvaga. Khoramu yekutanga iri mune yakatsvaga kiyi yakatsanangurwa mu 'search_key'.

Index: Iyo index index yemubhadharo unofanirwa kudzoserwa, apo iyo yekutanga ikholamu mu 'mhando' yakaverengerwa 1.

i_akasarudzika - [yakasarudzika]: Inotaridza kuti ikholamu ichange ichitsvaga (ikhoramu yekutanga yeiyo yakatsanangurwa) yakarongerwa, mukati mayo mutambo wepedyo we 'search_key' uchadzoserwa.

VLOOKUP(search_key, range, index, [is_sorted])

Mibvunzo Inowanzo Bvunzwa

Ndeipi nzira yekuuraya iyo vlookup basa muGoogle mashizha kuti utsvage kukosha kune iyo kolamu uye adzorere kukosha kubva mumutsara mumwechete mune yakatarwa chikamu?

Kuti uite vlookupu muGoogle mashizha, shandisa formula `= vlookup (yekutsvaga_key, renji, index, [is_sormed])`. Chitsiva `Kutsvaga` Kutsvaga` kukosha kwekutsvaga, neyendex yeCely yekutsvaga, uye `[is_masired] mutambo chaiwo.