Sida loo sameeyo Vueup-ga xaashiyaha Google?

Waa maxay Vueup-yada Google

Sameynta aragtida 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.

Hawsha 'Vlookup', oo macnaheedu yahay eegis toosan, waxay iskaan-gelin doontaa liiska xog ee toosan, iyo, markay hesho isku-dheelitir qiime leh, waxay soo celin doontaa qiimaha lagu keydiyay unug la codsaday ee xariiqa u dhigma qiimeynta Google Sheet Vlookup.

Marka ugu horeysa, si aad u sameyso Vindowup Xaashiyaha Google, waa inaad ku bilowdaa  Xaashiyaha Google   ee jira oo ay ku jiraan liiska xogta.

Sida loo sameeyo Xaashida Google Sheet

Markaad sameyneyso Xaashida Google Sheet, waxaa suurtagal ah in la raadiyo qiimayaasha ka dambeeya unug u dhigma qiime la siiyay, isla isla jumlada

For example, in above example, using a Vlookup in Xaashiyaha 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 Xaashiyaha Google

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

Gali xargaha si aad uga baarto liiska kale ee qiimayaasha, xulo liiska qiimayaasha soo galaya tixraaca, ama adiga ku xulo adigoo adeegsanaya jiirka: ka bilow qiimaha ugu sareeya liiska raadinta, kuna dhamee qiimaha ugu hooseeya liiska qiyamka lagu laabto.

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  Xaashiyaha Google   as index value.

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

Suurtagal kale ayaa ah in la sameeyo firfircooni xaashi xayeysiis ah oo Google ah iyada oo loo adeegsanayo furaha raadinta tixraac unug kale oo ku jira Xaashida Google, halkii aad ku qori lahayd qiimo gaar ah.

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

Noqo Prolel Pro: Ku soo biir koorsadeena!

U dhaaf xirfadahaaga Novice si geesinimo leh oo leh koorsadeena 365 ee caadiga ah, oo loogu talagalay in lagugu dhigto mid aad ku wanaagsan oo aad ku qanacsan tahay.

Halkan ka qor

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

Xaashiyaha Google Vlookup help detail

The  Xaashiyaha Google   Vlookup gives the following details:

Soo Koobid: Baaritaan toos ah. Wuxuu raadiyaa safka koowaad ee xaddiga furaha wuxuuna soo celiyaa qiimaha unug cayiman oo isku xigta la helay.

search_key: Qiimaha raadinta. Tusaale ahaan, '42', 'Cats' ama 'I24'.

Range: Tirada loo fiirsado raadinta. Safka ugu horeeya ee baaxadda ayaa la raadinayaa furaha lagu qeexay 'search_key'.

Index: Tiirka tiirarka qiimaha la soo celinayo, halka safka ugu horreeya ee '' tiro '' la tirin karo 1.

is_sorted - [ikhtiyaari]: Waxay muujineysaa in khaanadda la baarayo (safka ugu horreeya ee tirada la cayimay) la kala soocay, marka ay dhacdo ciyaartii ugu dhow ee 'baadi goobka' la soo celiyo.

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

Su'aalaha Badanaa La Isweydiiyo

Waa maxay habka loo fulinayo Fikradda Muuqaalka Farshaxanka ee Xogta Google ee Google si toos ah u raadiya qiime safka oo isku safka ku soo celiya isla safka la cayimay?

Si aad u fuliso Muuqaalka Wakiilka Google Grotlets, isticmaal qaaciddada '= Vinell_key', baaxad, tusmo, tusmo, [sented]). Ku beddelo 'qiimaha_keyt' oo ay la socoto kala-soocidda unugyada kala duwan ee lagu baarayo gudaha, 'Tilmaamaha' Tilmaanta Tilmaanta ee qiimaha lagu soo celinayo, iyo '[waa_Sorted] oo ay run u tahay qiyaasta ciyaarta ama been ciyaar sax ah.