Microsoft Excel VLOOKUP Function Tutorial Part 3

[mac200028542]

Really like the videos, thank you for the tutorials. Never knew anything about vlookup or that u can make a database out of Excel. Hope this helps me land an upcoming job.:)

[graham11545]

I enjoy watching your tutorials

[sikhpeace]

yeah, really great tutorials, thank you! :)

[Heartaken]

wwwwwwwwwwwwwwwwowwwwwwwwwwwww­w.... this is ingenious! LOL! im enlightened!!!!!!!!!!!!!!!!!!!­!!!!!!!!!!!!!! you really explain very clearly every little single action you do! awesome! THANKS! GOD BLESS! Yes, i enjoyed it very much!

[pnagaraj1]

Excellent tutorial. Its really good.

[lisal18]

Thank you much!!! You are wonderful!

[Maneby]

The playlist doesn't have this video (part 3) after the part 2!

[kfiatuszek00]

Hi, one question:say you send the sheet to someone else by email, do you have to include the table you took info from (you use grades or hardware) or just the results? If you didnt would it mess up the formula or would they still be able to read the results?

[MargieArana]

thank you very much for this video!!!!!!!!

[chrystalgoddess]

Thank you for all your help with Excel! I have always felt overwhelmed by all the things Excel can do, but your instruction was very easy to understand and definitely put the information into a format that I could understand. You helped me very much!

[DSCP46]

I've learnt so much tonight watching all your video's. I seriously watched all your video's one after the other. In a world that is getting ever more demanding, your making a big differance to many peoples lives. You may not even be aware how much so. God bless you for your brilliant video's, your commitment, and selfless efforts.

[CantFndaName]

Could you please explain "how to round-up to the closest match", like a Result of 39 still have a grade F (how to change it to E?).

Thanks a lot!. You are a very good teacher.

[stephenbyce]

instead of leaving the section blank of entering true you put either 1 or -1.

So is would be vlookup(B4,grades,2, 1 or -1)

[DSCP46]

CantFndaName, To make 39 an E, in the data table, change the 40, to a 39.

This will make 0-38 result to F, and 39-59 an E.

[TheCyoruk]

thx

[19altho68]

hey, what did you do in column D? please tell me how.. thanx

[fe1ixsam]

Just select column D, Format->Cells->Patterns->Cell color shading 'gray'

[outyougo3]

he pressed the D and that selected the row then he clicked on the paint bucket and made the fill color gray 25%

[ghamith]

Thank you

[ksibtain]

Thank you so much for the series!

[arza1978]

your tutorials have been very useful..thank you very much indeed!!great teacher.

[Baobao531]

非常感谢！！！

[datfire13]

I have been through all of your tutorials and have enjoyed them very much. Great instruction. I was looking for one particular problem though that I did not find covered in your series. How do I sort a column of numbers by numerical value? I keep ending up with numbers such as 0, 10110, 1070, 108, 11, 1248, 9...etc. It seems to be sorting from left to right by digit value instead of whole number value.

[MotionTraining]

Hi. It looks like the values have been formatted as text and not as numbers. Select the range of numbers then click on Format and then click Cells. In the list on the number tab make sure that the selected cells are formatted as numbers. Simply click 'number' and adjust decimal places as required. Once done, Excel will sort numerically. Hope that helped!

[datfire13]

That was exactly the problem. Thanks!

[fab188]

Great teaching. Extremely useful and easy to follow. Congrats.

[Tonty53]

Bello!Effettivamente la funzione Vlookup è una funzione di cui si sente l'esigenza quando si utilizza Excel.

Spiegazione chiara e semplice.

Bravo!

[MotionTraining]

Ciao Tonty53, grazie per tutte le vostre osservazioni. Buona fortuna con i vostri progetti Excel!

[Tonty53]

Bello! Effettivamente Vlookup è una funzione di cui si sente il bisogno quando si usa Excel.

Spiegazione chiara e semplice.

Bravo!

[imjustwow777]

fantastic!! thanks again.

[ImPanos]

Excellent. Only problem is what happens if in the list of students someone has the same name or surname.

[MotionTraining]

Hi. In this example the student score is the lookup value so the name duplication issue is not relevant. When you set up a data table (table array) only the first column needs to contain unique values. You can repeat information everywhere else as much as you want. Do not use values in the first column of your data table that are likely to contain duplicates. The lookup will not work correctly in this case.

[LordHashma]

I'm a biology/pre-med student at the University at Buffalo and will be teaching one of the freshman biology labs next year. I will need to use Excel for grading, and this set of tutorials was SUPERB...couldn't do all that without the help. Thanks!

[MotionTraining]

Hi LordHashma, thank you for the comment. I really appreciate the feedback and it's great to hear that these tutorials have been so helpful for you.

[LordHashma]

Well, right now I work in a research lab at the UB School of Medicine and we need to use Excel for many of our data analysis so these tutorials came at the right time!