?? Work at Pickup Points � Flexible schedule

VLOOKUP Excel 2010 (Advanced)

Mathew 652 views

Download Video

Comments

Excellent video with clear explanations and simple examples
Comment from : @GyOm1976

Trillion thanks for your tutorial course on Vlookup as it helps me to overcome the problem I have in my daily job
Comment from : @anthonyyung3387

And what if the student row is appearing next to test3 row? How to do that ? Can you please explain
Comment from : @soundapanmanoj5207

how to do that filter? Showing only one name
Comment from : @MrFreakyPulp

lol i wished i found your tutorial video before my technical interview i c ouldn't do vlookup as i had no idea what it does or how it worked Now, I understand!! I will continue to do more practice until I get a hand of it
Comment from : @chopaface

Great help, short and sweet,
Comment from : @justsayin1

Thank yiuu
Comment from : @abdhammid8042

Thanks Dear such a nice and valuable video i really like it
Comment from : @maju7799

is it advanced? OOHHHHHHHHHHHH PLEASE MAN! send it to "vlookup" for dummies book!
Comment from : @afonsoalbrecht1419

hindi
Comment from : @kamalbairagi

hi Mathew I'm new to vlookup I'm just wondering why didn't you use false at the end of your function?
Comment from : @rebeccaayala9331

helped a lot, thanks sir
Comment from : @Monangg

thanks for information
Comment from : @sarafsk2689

NICE VIDEO
Comment from : @heenasoni5274

Thanks, I come from bangladesh
Comment from : @KhairulIslam-on3us

Wow rob is a dumbass
Comment from : @luisvilla799

very interesting
Comment from : @giorgilobjanidze8297

You are the best
Comment from : @TheHappymyo

Hi Matthew, I am trying to follow your great examples and have run into a snag with the #N/A errors I have entered a $ in front of the row and the column and this still does not fix my problem after entering the $ signs and F4 I attempt to drag the formula down and excel drags the same result for each column PLEASE HELP!
Comment from : @msbrendag1

This is really help fullbrthank you
Comment from : @arnoldida7714

thanks
Comment from : @skdamale

very useful thanks
Comment from : @katwhy8

Thank you
Comment from : @arfanm9440

Your the fucking man Thanks!
Comment from : @devrenwashington9908

Thank you for this!
Comment from : @mitchkelly6179

what is the roll of 2 in your lookup formula
Comment from : @indiagrain_group

Nice excercise
Comment from : @drm9514

Nice explanation SIr
Comment from : @rajyogafitnessclub

How we use this function when i want output date formate??
Comment from : @clemiraclothing

Hi Matthew, your video was very helpful, i followed the tutorial twice and i was able to use the function on my spreadsheet I am so excited Thanks
Comment from : @anneebinum5696

i want to put the pictures in the excel 2016 can you have me ?bri find in the internet not seebrhelp me brother?
Comment from : @vannyleng3899

hi matthew, just wanna ask how did u put a drop down list on the name?
Comment from : @jakepaul491

hello,dear sir how did you fix the all students name my mean when you click on the "right click"
Comment from : @ramawatarbohara1803

hihow to use vlookup
Comment from : @kuldeepsharmaji

This is very basic VLOOKUP
Comment from : @MsAmanuell

This useful tutorial gives me a BIG HELP!brBe Honest, even though I watched many vlookup tutorials in my mother language before, I still felt confused on using vlookup till I have found this video!!!!
Comment from : @Mslyoiku

$? don't understand
Comment from : @mohammednurulaziz5758

Nice video, explained in simplest way
Comment from : @golenitin

Thank you
Comment from : @arunvu145

Yes, very useful
Comment from : @sokchanyuthcad4253

If you want to have vlookup work properly for the college/GPA example you must put 0 or FALSE The default (ie if you put nothing this is what excel does automatically), which is used in the video, is 1 (TRUE) which does NOT give an exact match, and in fact the values found are incorrect Similarly, for the first example, it is possible to use the second "Wrong Table", as long as you put -1 as the last argument of vlookup
Comment from : @francescahaack4394

hi, Mathew Pous how come VLOOKUP for Jerry's college is showing as "Bauer", when the value in table array is actually "Hilton"?brSimilar error for Jerry's GPA scores
Comment from : @sacmat16

Rob really needs to get back in the game
Comment from : @ethandesouza

Definitely some neat tips as far as the table order!
Comment from : @Agroskater

How come your Vlookup formula does not contain TRUE or FALSE?
Comment from : @MissWinnieLin

Perfect example
Comment from : @huskidusk

AMAZING BETTER THAN MY TEACHER
Comment from : @zhiweiyang1583

Thank you very much
Comment from : @RakibHasan-rp8he

For the student ones you dont have to sort out the table When building a vlookup formula, you do want to put false at the end of the formula so the exact match will appear
Comment from : @murtazaev