Excel Exception Two Way Way Ho sebelisa VLOOKUP Karolo ea 1

Ka ho kopanya mosebetsi oa VLOOKUP oa Excel le tshebetso ea MATCH , re ka etsa mokhoa o tsejoang ka mokhoa o peli kapa oa bobeli oa ho fumana mokhoa o lumellang hore u khone ho hlahloba lintlha tse peli tsa tlhahisoleseding boitsebisong kapa tafoleng ea data.

Tlhahiso ea litsela tse peli e thusa ha u batla ho fumana kapa ho bapisa liphello tsa maemo a fapa-fapaneng a fapaneng.

Mohlala o bontšitsoeng setšoantšong se ka holimo, foromo ea ho batla e etsa hore ho be bonolo ho fumana litekanyetso tsa khoebo bakeng sa li-cookie tse fapaneng ka likhoeli tse fapaneng feela ka ho fetola lebitso la cookie le khoeli lisele tse nepahetseng.

01 ea 06

Fumana Boitsebiso boemong ba Intersection Point ea Row le Column

Thuto ena e robehile likarolo tse peli. Ho latela mehato e thathamisitsoeng karolong e 'ngoe le e' ngoe ho etsa moralo oa litsela tse peli o bonngoeng setšoantšong ka holimo.

Thupelo e kenyelletsa sehlahisoa sa MATCH ka hare ho VLOOKUP.

Ho betla mosebetsi ho akarelletsa ho kenya mosebetsi oa bobeli e le o mong oa lintlha tsa mosebetsi oa pele.

Thutong ena, mosebetsi oa MATCH o tla kenngoa e le VLOOKUP moqolo oa nomoro ea lenane la khoeli .

Tutorial Contents

• Ho kenya Tutorial Data
• Ho theha Boemo bo Nang le Lebitso la Letlapa
• Ho qala mosebetsi oa VLOOKUP
• Ho kenyelletsa Phapang ea Boleng
• Ho kenya Lethathamo la Lethathamo la Khohlano
• Ho qala Mosebetsi oa MATCH oa Nested
• Ho eketsa Litsela tsa Data bakeng sa Mosebetsi oa MATCH
• Ho eketsa mofuta oa Match le ho tlatsa mosebetsi oa MATCH
• Ho tlatsa mosebetsi oa VLOOKUP
• Ho eketsa Matšoao a ho Batla ho Lekola Foromo e Phethahetseng
• Ho kopitsa Sebopeho sa Bobeli ba Liteboho le Fill Handle

02 ea 06

Ho kenya Tutorial Data

Mohato oa pele thupelong ke ho kenya data ho Excel sheet sheet .

E le hore u latele mehato ea thupelo ho kenya data e bontšitsoeng setšoantšong ka holimo ho lisele tse latelang.

• Kenya data e ka holimo ho lisele D1 ho F1
• Kenya moeli oa bobeli ho lisele D4 ho G8

Melao ea 2 le ea 3 e sala e se na letho e le hore e sebetsane le lits'ebetso tsa ho batla le foromo ea ho batla e entsoeng nakong ea thupelo ena.

Thupelo ha e kenye mokhoa o bonngoeng setšoantšong, empa sena se ke ke sa ama tsela eo foromo ea ho hokahanya e sebetsang ka eona.

Tlhahisoleseding mabapi le dikgetho tsa ho etsa dintho tse tshwanang le tse bontsweng ka hodimo di fumaneha ho Tetorial ena ea Basic Excel Formatting .

Lithuto tsa Thuto

1. Kenya data joalokaha e bonoa setšoantšong ka holimo ho lisele D1 ho G8

03 ea 06

Ho theha Boemo bo Nang le Lebitso la Letlapa

Botumo bo boleloang ke mokhoa o bonolo oa ho bua ka mefuta e mengata ea data ka foromo. Ho e-na le ho thapa litlalehong tsa lisele tsa data, o ka thathamisa lebitso la marang-rang.

Molemo oa bobeli bakeng sa ho sebelisa lebitso le lengata le lengata ke hore litemana tsa lisele tsa mofuta ona ha li fetohe le ha mokhoa o ngolisitsoeng o kopitsoa lisele tse ling lefapheng la mosebetsi.

Lithuto tsa Thuto

1. Totobatsa lisele tsa D5 ho G8 kahare ho li khetha
2. Tobetsa lebokose la lebitso le fumanehang ka holimo ho lintlha tsa A
3. Tlanya "tafole" (ha ho na litlhaku) ho Lebokose la Lebitso
4. Tobetsa konter ENTER ho lebokose
5. Lisele tsa D5 ho G8 li na le lebitso la "tafole". Re tla sebelisa lebitso bakeng sa khang ea VLOOKUP litlhōlisano hamorao thupelong

04 ea 06

Ho bula lebokose la puisano la VLOOKUP

Le hoja ho ka khoneha hore o thaepe foromo ea ho etela ka ho toba ka selefouno, batho ba bangata ba thatafalloa ke ho boloka poleloana e nepahetseng-haholo-holo bakeng sa moralo o rarahaneng o kang oo re o sebelisang thutong ena.

Ntho e 'ngoe, tabeng ena, ke ho sebelisa lebokose la lebokose la VLOOKUP. Hoo e batlang e le mesebetsi eohle ea Excel e na le lebokose la lebokose le u lumellang hore u kene mabaka a mosebetsi ka lehlakoreng le le leng.

Lithuto tsa Thuto

1. Tobetsa seleng F2 ea leqephe la mosebetsi - sebaka seo liphetho tsa mekhoa e mabeli ea ho kopa litekanyetso li tla bontšoa
2. Tobetsa Tlhahlobo ea letlapa
3. Tobetsa ho kgetho ea Lookup & Reference ka har'a lane ho bula lenane la ho theoha fatše
4. Tobetsa VLOOKUP lenaneng ho hlahisa lebokose la lebokose la mosebetsi

05 ea 06

Ho kenyelletsa Phapang ea Boleng

Ka tloaelo, bohlokoa ba ho batla bo bapisa tšimo ea data boemong ba pele ea tafoleng ea data.

Mohlala oa rona, bohlokoa ba ho batla ho bua ka mofuta oa cookie re batlang ho fumana boitsebiso bo mabapi le.

Mefuta e amohelehang ea data bakeng sa bohlokoa ba ho hokela ke:

• data data
• tekanyo e utloahalang (TRUE kapa FALSE feela)
• nomoro
• sebopeho sa sele ho ea bohlokoa boemong ba mosebetsi

Mohlala ona re tla kenella selefouno ea sele ho ea hokae lebitso la cookie - cell D2.

Lithuto tsa Thuto

1. Tobetsa mohaleng oa li- lookup_value lebokoseng la dialog
2. Tobetsa seleng ea D2 ho kenyelletsa sebaka sena sa lisele ho lookup_value line. Ena ke sele eo re tla thaepa lebitso la cookie mabapi le seo re batlang tlhahisoleseding

06 ea 06

Ho kenya Lethathamo la Lethathamo la Khohlano

Tsela ea tafole ke tafole ea data eo foromo ea ho batla e batlang ho fumana boitsebiso boo re bo batlang.

Lethathamo la tafole le tlameha ho na le bonyane lihlopha tse peli tsa data .

• khalala ea pele e na le khang ea bohlokoa ea ho fumana (mohato o fetileng thupelong)
• ea bobeli, le mehala e meng e eketsehileng, e tla phenyekolloa ke foromo ea ho batla ho fumana boitsebiso boo re bo tsebang.

Tlhaloso ea tafole ea tafo e tlameha ho kenngoa e le mobu o nang le litšupiso tsa sele bakeng sa tafole ea data kapa lebitso la mabitso .

Bakeng sa mohlala ona, re tla sebelisa lebitso la mabitso le entsoeng mohato oa 3 oa thuto ena.

Lithuto tsa Thuto

1. Tobetsa tafoleng_thathamo ea molaetsa lebokoseng la lebokose
2. Tšoaea "tafole" (ha ho litemana) ho kenya lebitso la mabitso bakeng sa khang ena
3. Tlosa lebokose la lebokose la mosebetsi oa VLOOKUP o bulehileng karolong e latelang ea thuto

Tsoela Pele Karolong ea 2 >>