How to Use the Excel 2007 VLookup Function

[TheChainslugger]

nice tutorial it's a pity when screwed up the exam just because forgot this kind of thing,anyway could you show me the combination for if function and value lookup?I'm new in here so I haven't seen whether you have posted or not.thx

[talentnts]

thank u,



[mtaj1981]

Thanks for the Vid. Helped me out.

[jigargpandya]

thanks,it has saved my many hours :)

[one4all1000]

Couple things you didn't mention, that the first column in your table array needs to be your lookup value, and second that if that first column isn't sorted or it’s sorted in descending order then the range lookup needs to be FALSE.

[dnbambi]

cheeeers!

[otiebaby]

thank you!!

[fayaz3raj]

thanks, really helpful

[ifuckednatalietran]

fuck i wish i watched this video 5 years ago. i could have easily have passed my vlookup exam

[12345raja12345]

Thanks...

[ultimatepingpong999]

perfect man



[89NYY]

Thank You so much Bro!!!!!!!!!!!!!!



[soulrebel311]

Short, sweet, and simple...Thanks man!

[MrShacol245]

Very clear tutorial, thanks a lot man.......

[jonjon72886]

How do I write a command which will say the following. If a cell is greater than zero move down one row, if not delete row.

[UrbanAcer]

Thanks a lot! Great, clear tutorial

[missmona17]

Great tutorial - very straightforward!

[badalsamra]

Hi...Thank you for your tutorial. Actually I did everything as per the video but still m not getting the value for IN, getting (#NA).

Can u help me out wats wrong ??????

[N4RVS]

I don't get it.

[YouDigwal]

Thanks Buddy!!!!! u really help me to solve this problem. =)

[Atnasamify]

thanks, your tutorial helped cut down the time to understand the function and use.. :)

[1313sukhu]

Thanks a lot.. Ii's really helpful.



[Cryobot92]

Awesome video....you really helped me a lot.....thanks

[cnybkrdr]

Thank you Sir! One of the simplest and most effective demonstrations on the use of this formula I've seen!

[sabbsys]

Thank you!!! Nicely explained!

[MsEstelito]

Thanks a lot for this video



[ShaneDalton65]

Hey thanks all the way from Ireland, cheers

Shane

[hemangpancholi]

Thanks

[manivji]

Thank you... its really helpful and got clear understanding of using it..

vlookup minimizes the time , even it is of huge work,,

[rimpaloz1]

It was big puzzel for me how to fix the table. I got it now just select and press F4. Thanks lot for this video.

[Alexcherupara]

Thanks very much. God bless you

[MrCdstern]

I like this guy. He's cheery.

[syedjavvad]

Thank u very much for this Video..

[BennyHarassi]

@Nightmare365wj yea if jesus was some hick from rural texas..

[lgamer99]

thanks you so much for this!!1

[savvyoatutube]

Thanks! Mucho appreciated!

[chubely]

Say if you had Column C which has a price in it or something and you wanted the output to be B-C, how would you do that?

[Raaszhecku]

Nice tutorials, good sir! 

[azeez999]

thanks

[educampos81]

Very very good...You saved my job...Need to do it in 15 minutes before a very important meeting....Thx , Man!

[sosovirus]

Thanks Very Much

[jeremiahbabcock]

Thanks for the video!

[greenagnes]

you talk like a turtle

[fanofnothingface]

@greenagnes

Who cares. The video was helpful. Thank you to the gentleman that uploaded this. It helped me a great deal.

[JopoMiniMovies]

@greenagnes How does that even make sense, connotation much?