Yadda ake yin Vidiyo a cikin Shafukan Google?

Menene Vidiyo na Google Gobe

Ana aiwatar da kallon Google Sheet 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.

Vueup ɗin aiki, wanda ke nufin kallon tsaye, zai bincika jerin bayanai na tsaye, kuma, lokacin da ya sami daidaituwa tare da ƙimar da aka bayar, zai dawo da kimar da aka adana a cikin tantanin da aka nema na layin da ya dace da darajar Google Sheet Vlookup.

Da farko dai, don yin Vlookup Littattafan Google, dole ne ka fara da data kasance Google Sheet din dauke da jerin bayanai.

Yadda ake yin Google Sheet Vlookup

Lokacin yin Google Sheet Vlookup, yana yiwuwa a bincika abubuwan ƙimar da suka biyo bayan tantanin da ya dace da ƙimar da aka bayar, akan layi ɗaya.

For example, in above example, using a Vlookup in Littattafan Google, we will be able to find values for a given country, but we will not be able to find which country matches a specific value – this is because the Vlookup with search in the first column for a specific value, and return the value in the same line in another column, as far as mentionned.

Creating a Vlookup search in Littattafan Google

Start in a cell by typing below formula, and the  Littattafan Google   Vlookup will automatically help to complete the cell formula, and display the help with all details on how to use the function.

Shigar da kirtani don bincika cikin wani jerin kyawawan dabi'u, zaɓi jerin ƙimar da ke shigar da ma'anarta, ko ta zaɓa su da hannu ta amfani da linzamin kwamfuta: farawa a saman ƙimar binciken, kuma gama a ƙasan ƙimar jerin dabi'u don dawowa.

Make sure to take note of the number of columns separating the search column and the return column: it will be the number to enter in the Vlookup  Littattafan Google   as index value.

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

Wata hanyar kuma ita ce ta yin gwajin Google Sheet mai karfin gaske ta hanyar shigar da mabuɗin nema abin nufi ga wani kwayar a cikin Google Sheet, maimakon buga takamaiman darajar.

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

Kasance mai kyau Pro: Kasance da karatunmu!

Daukaka kwarewarku daga novice ga gwarzo tare da muxin muxinmu na 365, wanda aka tsara don sanya ku ƙwarewa a cikin 'yan zaman a cikin' yan zaman.

Rijista a nan

If you then change the value in the cell referred in the search function, the Vlookup  Littattafan Google   result will automatically be updated accordingly.

Littattafan Google Vlookup help detail

The  Littattafan Google   Vlookup gives the following details:

Takaitawa: Neman madaidaiciya. Yana bincika layin farko na kewayon maɓallin kuma ya dawo da ƙimar takamaiman sel a jere da aka samo.

search_key: Darajar nema. Misali, '42', 'Kutsi' ko 'I24'.

Range: Matsakaicin da za'ayi la'akari da bincike. Rukunin farko a cikin kewayon ana bincika maɓallin da aka ƙayyade a cikin 'search_key'.

Index: Shafin shafi na ƙimar da za a dawo, inda layin farko a 'kewayon' an ƙidaya 1.

is_sorted - [na zaɓi]: Yana nuna ko za a bincika allon da za'a bincika (shafi na farko na kewayon da aka ƙayyade), wanda a cikin saɓanin wasan da yafi dacewa na 'search_key' za a mayar dashi.

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

Tambayoyi Akai-Akai

Menene hanya don aiwatar da aikin kallo a cikin zanen Google don bincika darajar a cikin shafi kuma ku mayar da ƙimar daga jere a cikin takamaiman shafi?

Don aiwatar da kallo a cikin zanen Google, yi amfani da tsari `= VLOLOCUP (Search_key, Index, [is_sanged])`. Sauya 'Search_key` tare da ƙimar sel don bincika tsakanin, `ornxed]' tare da gaskiya don kusancin wasan ko na ƙarya don daidaitaccen wasa.