VLOOKUP u0026 HLOOKUP in Excel Tutorial

Video quality	The size	Download

Information VLOOKUP u0026 HLOOKUP in Excel Tutorial

Title	:	VLOOKUP u0026 HLOOKUP in Excel Tutorial
Lasting	:	6.30
Date of publication	:
Views	:	378 rb

He abused Jennifer and Eric with Excel Well, that's new😮
Comment from : @ReveredMaster

i am done now thanks very much
Comment from : @kingstonenyamwena7866

Very easy to folow thank you
Comment from : @blainecote8134

Amazing!!! Thank you 😊
Comment from : @Wilde_flower

Important tip for data organization: when you have a spreadsheet with a lot of columns: just make sure that the column with the lookup value is simply left of the column you want to search in The Vlookup function can only search to the right! Good luck 😊
Comment from : @ExcelEssentials_

Thank you so much this was very informative
Comment from : @kurstyphiloe7862

U made it so simple i won't forget this
Comment from : @user-cj3bu9cb8y

Hi Kevin You're my first choice for Excel training; thank you for the videos Can you recommend a monitor to use while working with Excel?
Comment from : @shareemsatellitellc7591

would have preferred that you zoom in completely on your screen
Comment from : @Star-vg7ix

ما احلاها التكنولوبيا
Comment from : @user-hn3qm9gm5v

Lob you ❤
Comment from : @NarutoUzumaki-ix2gx

WHAT EVEN
Comment from : @prernakjain5004

thank you so much
Comment from : @goodperson2785

amazing
Comment from : @adelineparker9525

Thanks for the video Kelvin, I do have a little challenge here with that of 'Matt' donation, how do you go about it if you want Excel to sum up the number of occurrences for a cell for example, in the case of Matt let excel sum Matt's donation to $15,100
Comment from : @EbenezerEbokye

thank you !!
Comment from : @brendamartinezgomez2297

Thanks
Comment from : @earlsackeyfio7977

I am AData Analyst because of you Kevin
Comment from : @tselisoramoeletsi95

This never gets old
Comment from : @babajideamure108

Excellent vid only thing is that the excel table is a bit blurry but totally excellent content for this vid
Comment from : @carloandrade9980

Excellent video!!
Comment from : @aloks_22

thxx budyyy very helpful videoo😀
Comment from : @mihirparab4266

that energy in the beginning is extraordinary🤣🤣🤣🤣
Comment from : @techmansgaming

Thank you so much sir 🙏🙏
Comment from : @ArigelaMaheswari-on7hk

Your'e brilliant Thank you
Comment from : @hlumisasili9952

reason to use false in last
Comment from : @ylio60

Thank youuu 🙌🏾🙌🏾🙌🏾
Comment from : @adenijiesther8

You're the best I wish I'm a lady, I'd love to give u a kiss 💯🙏 God bless you abundantly Kelvin, u put my long time fears to rest with your Pivot table lecture and this Vlookuo and Hookup lecture 🙏
Comment from : @jotech5951

Fantastic Kevin from NZ!!!
Comment from : @raymondmoore-pf9rx

loved your tutoring Keep it upJennifer and Eric sure need to donatelol
Comment from : @lyn1575

@kevin stratvert Please attach Excel files with videos for practice purposes
Comment from : @arshankhan6868

Kevin, thank you for this vlookup and your pivot table y'videos-- yes, I have created an acronym/abbreviation/phrase of youtube and video--as well These two videos explained things in a very simple manner I went the extra mile and created the spreadsheet's of the examples you show to actually do the vlookups, hlookups, and pivot tables as you show to GET the concept down and not be afraid or in the unknown of what they do
Comment from : @poriam9534

Simplest way to teach Amazing Thanks a lot Kevin
Comment from : @amar27kaur

Thanks for this I would watch over and over until it sinks into my subconscious I have been struggling with vlookup
Comment from : @jummyalfred2909

I love u
Comment from : @fernandoarguello8243

Much easier to understand
Comment from : @sjvanhuffel1986

Tx this was useful for my exams
Comment from : @sjvanhuffel1986

Respect Man
Comment from : @sandanakrishnan7114

YOU ARE A GENIUS!
Comment from : @tabbyc100

Thank you dude
Comment from : @premadak848

Your video was helpful Now how can i get both Matts to appear individually on the list breg If i have both two Matt's in each of the sheet
Comment from : @appahwoyengikuro3228

you're the reason I'm passing my CAT NSC tomorrow
Comment from : @miekie3164

honestly I just wanted to know in which data need to use hlookup and where vlokup but his beauty make me watch whole video although ik how to use formulaha ha ha women ha ha ha
Comment from : @shivanganiparmar3679

I have been trying to do a v-look up and with your tutorial it final workedthe one step I was missing was the data in the range I was looking in had to be the first column on the left Thank you so much!
Comment from : @reneejones920

I`m pleased❤, I started this today but now fully understand what`s happening, Keep it up!!!!!!
Comment from : @mbulahenirob

Thanks bro, you're great
Comment from : @LEAh-sm2ng

Thank you so much for this Tutorial
Comment from : @shekhfarid7715

Very very thanks
Comment from : @ruchikasharma8302

what if i have like 4 pages and in the fifth page i want to buld aan interface to doo the lookup thing tipe soñthing and it make me see the result with in all the pages if it fing a math for it how can i do it ? thank you
Comment from : @GazariZakaria

Too much of taking PLease reduce that GO straight to the point with example bro
Comment from : @srinivasansuresh1406

Is there another formula to solve the "Matt" issue?
Comment from : @akaalx

You are amazing!
Comment from : @user-md3ym9fp6h

Thank you Kevin for explaining the concept so clearly :)
Comment from : @pahadiinlondon

this was perfect at perfect time
Comment from : @ashirnadeem2627

Easily explained Kevin
Comment from : @ahedsiddique7628

You are handsome
Comment from : @ahedsiddique7628

Correctly explained
Comment from : @ahedsiddique7628

Thank you so much! Hopefully I pass my Computer Science exam now ;)
Comment from : @goofyahhh

Thanks alot!! 🙏
Comment from : @ChinmayLive

❤️❤️❤️❤️❤️❤️❤️👍👍👍👍👏👏👏👏👏
Comment from : @diamondngocanhcoin1265

This was simple and effective Thank you!😊
Comment from : @estherm3798

Very good video on teaching v and h lookup Goodwork!
Comment from : @clementtan8237

Firstly - Great, informative videobrbrHowever the approximate value uses little logic It initially returned a value of 50, meaning either "Doug" or "Sam" were deemed approximately "Jennifer", even though they share 0 letters and have less syllables Also, it didn't deem "Brian" an approximate match even though it does share letters with "Jennifer" So overall, pretty unreliable tool unless you're using the exact match
Comment from : @chrismotherwell5093

Thanks for the video! Really helpful Eric and Jennifer are probably regretting their decision now :)
Comment from : @juanpablomonteagudo2197

Danke!
Comment from : @patrickkurmann

Very simple to understand and it helped a lot Thanks for this!
Comment from : @jesherpalomaria7996

please how can i extract a list of data from a group of data? assuming i am having 500 personel's data with a unique identity code and i need to get 200 persons from the rest to have what is left how do i go about that?
Comment from : @agboolaisaiaholaide5267

Another solid video! Thanks my guy
Comment from : @Wildcard0094

Great video as usual what about XLookup
Comment from : @sozuki1

I am not American brbrCan someone tell me why do you donate to your school after paying for your education?
Comment from : @madaoanimelife2227

Best vlookup video
Comment from : @MostAwesomestChannel

Nice2 Learned it also for 6mins Heheheh thank you
Comment from : @odymamavlogs3409

Amazing and easy ☺️🎉
Comment from : @shahabuddinbadshah5028

Thanks man Simple and easy
Comment from : @davethomas101

Thank you so much for this! It was easy to follow
Comment from : @Hasna1919

KISS principle, you got it well, thank you
Comment from : @geanfelipemoura

Thanks Kevin I use vlookup all the time
Comment from : @palaniarumugam1533

Would like this twice if I could, thanks:)
Comment from : @danielradcliffe5918

Hi KevinbrHow do i combine the donation valeu's of the two Mat's using VLOOKUP? Or do i use a complete other formula to do this?
Comment from : @deechteflurk

Thank you so much I have lots of learned from your videos bro!! God bless you love from India
Comment from : @CoolSagar

I been looking for many videos to figure out how this equation works but I never finds how easy way to get results Wonderful
Comment from : @Thetrurth

Easiest way really you are genius
Comment from : @Thetrurth

The only thing I want to know why V look up or H look up?? I can't get why the V or the H at the beginning sorry if that's too simple
Comment from : @Carla369

Thanks againvery lazy to review these topics especially now that I speak English and all formulas change Thanks 😁
Comment from : @Carla369