Microsoft Excel VLOOKUP Function Tutorial Part 3
This third VLOOKUP tutorial show you how to retrieve ‘close’ matches from your data table and also how to incorporate the IF and ISBLANK functions to make
your VLOOKUP results more user friendly. I hope you find this tutorial helpful.
April 18th, 2010 at 11:58 am
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.
April 18th, 2010 at 11:58 am
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.
April 18th, 2010 at 11:58 am
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)
April 18th, 2010 at 11:58 am
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.
April 18th, 2010 at 11:58 am
he pressed the D and that selected the row then he clicked on the paint bucket and made the fill color gray 25%
April 18th, 2010 at 11:58 am
thx
April 18th, 2010 at 11:58 am
Just select column D, Format->Cells->Patterns->Cell color shading ‘gray’
April 18th, 2010 at 11:58 am
hey, what did you do in column D? please tell me how.. thanx
April 18th, 2010 at 11:58 am
Thank you
April 18th, 2010 at 11:58 am
Thank you so much for the series!
April 18th, 2010 at 11:58 am
your tutorials have been very useful..thank you very much indeed!!great teacher.
April 18th, 2010 at 11:58 am
???????
April 18th, 2010 at 11:58 am
That was exactly the problem. Thanks!
April 18th, 2010 at 11:58 am
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!
April 18th, 2010 at 11:58 am
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.
April 18th, 2010 at 11:58 am
Great teaching. Extremely useful and easy to follow. Congrats.
April 18th, 2010 at 11:58 am
Ciao Tonty53, grazie per tutte le vostre osservazioni. Buona fortuna con i vostri progetti Excel!
April 18th, 2010 at 11:58 am
Bello!Effettivamente la funzione Vlookup è una funzione di cui si sente l’esigenza quando si utilizza Excel.
Spiegazione chiara e semplice.
Bravo!
April 18th, 2010 at 11:58 am
Bello! Effettivamente Vlookup è una funzione di cui si sente il bisogno quando si usa Excel.
Spiegazione chiara e semplice.
Bravo!
April 18th, 2010 at 11:58 am
fantastic!! thanks again.
April 18th, 2010 at 11:58 am
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.
April 18th, 2010 at 11:58 am
Excellent. Only problem is what happens if in the list of students someone has the same name or surname.
April 18th, 2010 at 11:58 am
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!
April 18th, 2010 at 11:58 am
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.
April 18th, 2010 at 11:58 am
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!