Microsoft Excel VLOOKUP Function Tutorial Part 1

[Stromya42]

thanks so much mate, got an accountancy interview that are gonna test me on this and this tutorial really helped.

[B1ack4ng3L]

Wow! thanks very much, after watching this tutorials of your. i completely understand the function and formula of vlookup... thanks it helps me a lot

[DeeJayTDoggs2011]

thanks

[ochienw]

Great teaching, thanks.

[othmerk]

THANK YOU!

[user8878]

Thumbs up if you wanna see what this guy looks like! :D

[MyronMGains]

Searched for hours with VLOOKUP help, you my friend, have helped me.

[jessicachao9999]

I like this trainning material

Thanks for your shalling

I really understand the function of vlookup ^^

Jessica

[fayyaz19321]

Hello dear friends...

In this tutorial you are learn about Microsoft Microsoft Excel VLOOKUP Function ..

I am learning here daily if you have interest in learning about Microsoft Microsoft Excel VLOOKUP Function so please join you tube and search about which do you want learn..

Thanks dear friend for sharing with all community about this great tutorial...

[Rafiki161]

Once you entered the price, how did you get the Total section to calculate??? It didnt automatically do it for me ??

[TheMiketrupiano]

I'm entering the data on a spreadsheet while I watch this. The vertical formulas are working fine but I'm not getting the totals in the total column. It's remaining as '0'. Any help is appreciated. Great video and series!

[akh0120]

Thank you very much. your video have been extremely helpful and clearly explained.

I like the step by step but can you show the short cut too.

[iWriteUinMyDeathNote]

it messed up on screws price and stuff but it got the name right whats wrong

[majorrojam]

Most made mistake while working with vlookup is that excel sees numbers as text.And then vlookup doesnt work you need to change text to columns.

[MrMusicomane]

Amazing, I'm learning so much! Very interesting. God bless you :-)

[iza1st]

Thank you very much. Very clearly explained.

[Marriposa19]

i am practicing this and your videos have been extremely helpful. Question, after I am done with the table my totals do not appear, would you know why?I have gone step by step and I have not missed a step and my totals still do not appear. Help thanks

[gelolo020407]

poor audio man. please check thanks

[EDX282]

Thanks for the tutorial very helpful

[mppenrod]

I am studying for a test for a job. The videos have helped. Thanks

[cobraboy1997]

Great training, very clear and easy to understand.

You have saved me several times from Excel frustration.

Thanks,

[totallyprudent49]

Thank you so much for making these tutorials...your tutorials have really helped me at my new job. I started out not knowing anything about excel, not even basic cell referncing, but now im a pro.

thank yo so very much

[sasha1025]

Hey! I had been using your tutorial from the basic excel to vlookup! and this is EXCELLENT!

[ManicReverse]

Thx! V Good Tutorial

[rizbizdiz]

Its really use full for me,,, thanks alot,,

[faatbeezy]

good tutorial. could u pls tell me is there any reason you wouldnt just always name the table in second part of the formula (table_array) when using vlookup

[MotionTraining]

Hi. Thanks for the feedback. This video covers the basics of setting up a VLOOKUP calculation. Naming the data table - or table array - is covered in parts 2 & 3 of this video series. And yes, you're correct, it is a good idea to name the table.

[faatbeezy]

Thanks very much for the reply.

could i ask you why would there be three brackets at the end of this formula. Is it because there is two value if true conditions and one if false

=IF((AND(D2>5,C2>10000)),3,(IF­((OR(D2>5,C2>10000)),2,1)))

[choice3918]

@MotionTraining Hi! I have been following all your tutorials,but I got the problem in putting formula especially if I press the F4, in my pc, it doesn´t work. I did exactly the way you did, I even followed your sample several times, but it really doesn´t get the same outcome as yours. After putting all the formulas, the F4 and so on, but then, when pressing enter, the result in my pc appears as if no readable answer.Is there any other way how to input a formula into it wihout the use of F4?

[PaganBarleycorn]

At last! A clear and concise explanation of Excel, something I've been searching for for years. Thank you... I am not worthy bow :-)

[TheCyoruk]

thx

[sasha1025]

thanks for posting this.. this is indeed usefull..

[good2smile1]

Help, I am trying to match ssn's from two spreadsheet w/n a workbook, I've put the columns in ascending order, format to text, and I do every thing exactly as you describe in your example and the cell ends up displaying the formula. What am I doing wrong? I created a spreadsheet to mirror yours on the tutorial and it works, so I am not sure what I am doing wrong on the spreadsheet with the ssn's.

[pineapplesoup2009]

Thanks for the post - very helpful and my wife likes the sound of your voice!...... easy tiger.

[clarissjohn88]

thsnx 4 ur videos its been very useful to me. i learn a lot of things from u.tell me how can type a number which start from zero.i used to do it but it gives me only the number without the zero in it. thanx.

[MotionTraining]

press the apostrophe key before typing the number. For example: '007

[SUSYSOO]

thankyou, excellent tutorial style and very, very helpful :-)

[Loveseekingmissile]

I have Excel 2003 and f4 doesn't do anything, help please.

[MotionTraining]

Hi. Pressing F4 to apply the '$' signs for an absolute reference works in all versions of Excel. Open a blank workbook and, with A1 selected, type '=' then click any cell (apart from A1) and press the F4 key. If the '$' signs don't appear in the formula bar then your F4 key is not working!

[gingersnaps1105]

@loveseekingmissile: i don't know if this helps but you have to press f4 after you select the reference cells and BEFORE you hit enter or click elsewhere..

[sukianata]

very useful and helpful tutorial, thanks!

[abelethio]

thanks!

[Baobao531]

非常感谢！！！

[compluss]

Thanks a million, awesome video help

[destroyahdes]

How did you get the part that says description to be wider?

[1000xx]

Excelente video

[deckjesta]

You're a great teacher. I also watched your excel beginners tutorial. Very helpful for the national diploma I've just started. Thanks a lot mate

[imjustwow777]

I learned too....thank you!!

[MaestroChris]

I learned alot from this video! Great work!

[YiuTuber]

brilliant!