01 na 03
Nemi farashin farashin tare da VLOOKUP
Yaya Ayyukan VLOOKUP ke aiki
Ayyuka na Taswirar Google ɗin Wizard na VLOOKUP, wanda ke tsaye don neman dubawa , za a iya amfani dasu don bincika bayanan da aka samo a cikin tebur na bayanan ko bayanai.
- Ana iya samun bayani game da saƙonnin kuskuren VLOOKUP a shafi na 3
VLOOKUP kullum yana dawowa guda guda na bayanai a matsayin fitarwa. Ta yaya wannan yake:
- Kuna samar da suna ko search_key wanda ya gaya wa VLOOKUP wanda jere ko rikodin lissafin bayanai don bincika bayanai da ake so
- Kuna samar da lambar mahaɗin - wanda aka sani da alamar - na bayanan da kuke nema
- Ayyukan suna nema don search_key a cikin sashin farko na layin bayanai
- VLOOKUP sa'an nan kuma gano wuri kuma ya sake dawo da bayanan da kake nema daga wani filin na wannan rikodin ta amfani da lambar haɗin da aka bayar
Gano Matakan da suka dace da VLOOKUP
A yadda aka saba, VLOOKUP yayi ƙoƙarin neman matakan daidai don neman search_key . Idan ba za a iya samun daidai ba, VLOOKUP na iya samun kimanin wasa.
- Kimanin kusan shi ne mafi kusa da wasan zuwa search_key a girman da yake karami ko ƙasa da darajar.
- Ana samun matakan da suka dace kusa da ƙaddamar da aikin da aka yi a TRUE.
Kaddamar da Bayanan Na farko
Ko da yake ba a koyaushe ake buƙata ba, yana da mafi kyawun mafi dacewa da farko da zaɓin kewayon bayanan da VLOOKUP ke nema ta hanyar amfani da maɓallin farko na kewayon don maɓallin iri.
Idan ba'a samo bayanan ba, VLOOKUP zai iya dawo da sakamako mara kyau.
Sakamakon aiki na misali
Misali a cikin hoton da ke sama yana amfani da mahimman tsari wanda ya ƙunshi aikin VLOOKUP don samun rangwame don yawan kayan da aka saya.
= VLOOKUP (A2, A5: B8,2, TRUE)
Ko da yake ana iya yin amfani da maƙallin da aka ambata a cikin saitunan aiki, wani zaɓi, kamar yadda aka yi amfani da matakan da aka lissafa a ƙasa, shine amfani da rubutattun kalmomi na Google don nuna shigar da wannan tsari.
Shigar da aikin VLOOKUP
Matakai don shigar da aikin VLOOKUP wanda aka nuna a cikin hoton da ke sama cikin sel B2 shine:
- Danna kan tantanin halitta B2 don sa shi tantanin halitta - wannan shine inda za a nuna sakamakon VLOOKUP
- Rubuta daidai alamar (=) bi da sunan aikin vlookup
- Yayin da kake bugawa, akwatin zane - zane yana nuna tare da sunaye da haɗin ayyukan da suka fara da wasika V
- Lokacin da sunan VLOOKUP ya bayyana a cikin akwati, danna sunan tare da maɓallin linzamin kwamfuta don shigar da sunan aikin kuma buɗe sashin zagaye a cikin jikin B2
Shigar da Magana Magana
- Ana iya samun cikakken bayani game da ladabi da kuma muhawarar VLOOKUP a shafi na 2
- Kamar yadda yake a cikin Excel, ana sanya takaddama a tsakanin ƙwaƙwalwar aiki don aiki a matsayin mai raba.
Ana shigar da muhawarar aikin VLOOKUP bayan an bude sashin layi a cikin tantanin halitta B2.
- Danna kan A2 a cikin takardun aiki don shigar da wannan tantanin halitta kamar ƙudurin search_key
- Bayan nazarin tantanin halitta, rubuta takaddama ( , ) don aiki a matsayin mai raba tsakanin gardama
- Sanya siffofin A5 zuwa B8 a cikin takardun aiki don shigar da waɗannan maƙallan siginar kamar jigidar jigilarwa - ba a haɗa su a kan kewayawa ba.
- Bayan tantanin salula, rubuta wani takaddama
- Rubuta 2 bayan comma don shigar da ƙididdigar ƙididdiga tun lokacin da aka samu farashin rangwame a shafi na 2 na jigidar gardama
- Bayan lambar 2, rubuta wani takaddama
- Sakamakon sauti B3 da B4 a cikin takardun aiki don shigar da waɗannan maƙallan sutura kamar yadda ake biki
- Rubuta kalma Gaskiya bayan fashewar azaman ƙaddamarwa maras kyau
- Latsa maɓallin shigarwa a kan keyboard don shigar da takalmin rufewa " ) " bayan aikin aikin karshe kuma don kammala aikin
- Amsar 2.5% - yawan rangwamen kudin da aka saya - ya kamata ya bayyana a cikin sel B2 na takardar aiki
- Lokacin da ka danna kan tantanin halitta B2, cikakken aikin = VLOOKUP (A2, A4: B8, 2, Gaskiya) ya bayyana a cikin maɓallin tsari a sama da takardun aiki
Me yasa VLOOKUP ta dawo 2.5% a matsayin sakamakon
- A cikin misalin, ɗakunan Maɗaukaki ba su ƙunshe da daidai daidai don ƙimar binciken_key na 23 ba.
- Tun da aka ƙaddamar da gardamar da ba'a da ita ga TRUE, VLOOKUP zai sami kimanin dacewa zuwa darajar search_key .
- Ƙimar mafi kusa ta girman da yake ƙananan ƙananan ƙimar search_key na 23 shi ne 21.
- Saboda haka, VLOOKUP, yana duban rangwamen kashi a cikin jere da aka ƙunshi 21, kuma, a sakamakon haka, ya dawo da farashin bashi na 2.5%.
02 na 03
Shafukan Lissafi na Google VLOOKUP Ayyuka da Magana
Hanyoyin Sakamakon Tasirin VLOOKUP da Magana
Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara .
Hadawa don aikin VLOOKUP shine:
= VLOOKUP (search_key, range, index, is_sorted)
search_key - (da ake buƙatar) darajar don bincika - kamar yawan da aka sayar a cikin hoto a sama
yanayi - (da ake buƙata) yawan ginshiƙai da layuka waɗanda VLOOKUP zasu bincika
- shafi na farko a cikin kewayon ya ƙunshi search_key
index - (da ake buƙata) lambar mahaɗin darajar da kake son samu
- ƙididdiga ta fara da shafi na search_key a shafi na 1
- idan an saita lakabi zuwa lamba mafi girma fiye da adadin ginshiƙai da aka zaɓa a cikin ƙaddamar da gardama a #REF! An dawo da kuskure ta hanyar aikin
an aika - (na zaɓi) yana nuna ko ko dai ba a haɗa jeri ba a tsari mai hawa ta amfani da shafi na farko na kewayon maɓallin maɓallin
- Ra'idar Boolean - TRUE ko FALSE ne kawai ƙimar yarda
- idan an saita zuwa TRUE ko kuma ba a cire ba kuma shafin farko na kewayon ba a rarrabe a cikin tsari mai hau ba, wani sakamako mara daidai zai iya faruwa
- idan aka cire, an saita darajar zuwa TRUE ta hanyar tsoho
- idan an saita zuwa TRUE ko kuma an cire shi kuma ba a samo daidai ba don search_key ba, matsala mafi kusa da girman da girman da ake amfani dashi shine search_key.
- idan aka saita zuwa FALSE, VLOOKUP kawai tana karɓar daidai matsala don search_key. Idan akwai matakan daidaitattun lambobi, an mayar da lambar farko ta daidai
- idan aka saita zuwa FALSE, kuma babu matakan da ya dace don search_key an samo kuskuren N / A da aikin
03 na 03
Saƙonnin kuskuren VLOOKUP
Saƙonnin kuskuren VLOOKUP
Saƙonnin kuskure masu zuwa suna hade da VLOOKUP.
Ba'a samu N N / A ("darajar ba") ba idan:
- Ba a samo search_key ba a cikin sashin farko na jigilar lamuni
- Tabbatar da kewayar ba daidai ba ne. Alal misali, jayayya na iya haɗawa ginshiƙai maras amfani a gefen hagu na kewayon
- An ƙaddamar da hujjar da aka ba da ita zuwa FALSE kuma daidai matsala don binciken bincike_key ba za a iya samu ba a cikin ɓangaren farko na kewayon
- An ƙaddamar da gardamar da ba'a da ita ga TRUE da dukan dabi'u a cikin sashin farko na kewayon ya fi girma a cikin search_key
A #REF! (kuskuren "daga cikin kewayon") an nuna kuskure idan:
- Shawarar ƙididdiga ta fi girma a kan adadin ginshiƙai a cikin jigilar lamarin