Thank you so much. I also just stuck up with this problem for 1hour, then search your video and solve it in 1minute. You are just the best teaching instructor. Thanks a ton.❤
FINALLY! My college prof instructions are vague. He didn't mention referencing the cell next to the empty one I am trying to find. You saved me in 1 minute and 30 seconds. Been stuck for hours!
Thank you so much, I was on the internet for long hours just trying to find this, all the other videos explain the entire range with ranking formula, but your tutorial was the ultimate answer to my search. Thanks A lot dear
Maazmujahid You are very welcome and I am so pleased that my video was the ultimate answer for you. Thank you for taking the time to leave your comment.
Hi Zulfikar, You are very welcome and I am delighed that my Vlookup Tutorial gave you an exact understanding of the function. I am an professional IT Trainer who enjoys helping others learn.
Hi Amanda, I am delighted that my Vlookup Tutorial made it easy for you to learn how to use this formula. Thank you for your lovely comment. Enjoy Excel!
Hi IPAPC, You're very welcome. Delighted it worked. It’s such a good feature too. Can’t be undone with usual formatting as the condition has to be deleted before it can be removed.
Thank you! I was looking for guides online to do this but I couldn't figure out how as I'm quite new to excel but this video has saved me, thank you. You explain really well :)
Keen you are very welcome and I am delighted that my tutorial helped you with the understanding you needed. Thank you for your lovely comment. Good Luck with college.
Miriam, I have one more question. I have rankeda table of scores and they appear as 1,3,2,5,6,7 etc and I wanted to show 1st, 2nd and 3rd at the side of the table to make it easier to see medal winners at a glance - if you can understand what I mean, can you assist. Thank you, Neil
why i have N/A error ?? my problem is to say "fail(note from 0--10),pass(10--12),good(12---16),excellent(16--20)" after finding the average if a student,but still have the N/A error.. how to fix ?!
Hi George, N/A in Excel Vlookup means that you have an error. It means Not Available. This is usually displayed when Excel can't find the look up Value. To rectify, make sure you have your lookup table like the one in my video. Do not use used the parenthesis in your table. in the second column put in the the words for each grade besidee the relevent number. Enter 0 for the 'fail' option. Then select the entire lookup table and sort it into Assending Order before you input your Vlookup formula. I hope this helps.
@debbiesmith8778 Hi Debbie Here is a few things to check: 1)Ensure that your Vlookup Table is sorted by Ascending order by the first column, 2) Ensure that within your formula that the Vloopup Cell range is made Absolute - that means it has dollar signs for the beginning table cell and dollar signs for the ending table cell 3) Make sure that all comma etc are correct within the formula. I hope this helps you.
Miriam, your video has been a massive help - 1 question. Is it possible to colour code the value ast is returned, eg: A might have red text, b yellow, c blue and so on. This would make it easier on me to see the grade at a glance. Thank you
Agar f4 press karenge to humara cell fix ho jata h to jab hum formula wale cell to drag karte hai to wo drag nahi hota jese ki agar a2 cell mai 2 likha hai aur b2 cell aura3 m kuch value aur jab hum multiplied karenge to a2 bhi niche ki tarf drag na ho isliye
Hi IPAPC I have created a video in response to my understanding of your question Neil. It’s called Excel IF Function for scores. I hope it helps. If not, take a look at my response to Jay Ai’s query as this may also work for you. Alternatively you could just set up a Vlookup table with the scores one side and ranking on the other and then just input a Vlookup formulain the cell range where you require the results.
Once again sorry to bother but, I really don't know what you mean by click f4. Here my laptop is lenova and mine f4 is not showing same result as your. So their I was struck. I can't move on. Cause I was not able to get a result
Hi Tashi, The F4 Function key on your keyboard will make Excel 'cycle' through different types of cell references when you are inputting a formula. On your Lenova Laptop you have a Key Fn (usually on bottom left), Press this Fn Key as you press F4 Function key on the top row and you will get the same result as my tutorial. Each time you hold the Fn Key as you press the F4 Function key, Excel will present you with different cell reference type as my tutorial demonstrates. I hope this helps you.
Hello S Miriam, I have a question. In your tutorial teaching VLOOKUP function version 2010. Does it work the same for Windows 7? Reason I am asking is because the grade chart will not pop on windows 7. I was wondering how will I grade if chart if it does not come up? Truth be told...I am confuse! Best Regards, Margaret
Hi Margaret,I have not used a chart for the Grades reference area. I simply typed this information into the spreadsheet and then just applied green highlight to the area. For example, I decided anyone who scored between 55% and 59% was awarded D- and so on. Ensure that you do something similar. You then use your Grades area cell range as your Vlookup table in your formula.The VLookup is a formula and will work if the correct formula and cell references are used. I hope this helps. (Windows 7 is only the computer's operating system Margaret)
hi..can i ask for your help? i have a problem with excel.. i solve grades but the excel has a different result from my calculator.. how can i match the result of my calculator to my excel grade sheets? :( i hope you can help me..
Hi IPAPC I have created a second video in response to your ranking question (just in case I misunderstood your query!) It’s called Excel Rank Formula (on stepbystepbymiriam). It shows how to create a ranking for scores with an Excel Formula. Good Luck with all.
Hi Jay Ai If you are using the Vlookup technique to achieve your grades then you may need to have a look at my Vlookup with False video on as this only allows for exact matches. I also have a nice little video called How to calculate percentages for Exam grades in Excel. You could also enter an IF formula such as =IF(A1
Nice Question nishant! Vlookups can only handle data that is sorted in Ascending order. If the data in your Vlookup tables is not sorted in ascending order, then Vlookup may return an incorrect result. Also, Vlookup, cannot handle black cells or errors in the Vlookup table either, as it may return incorrect results. Hope this helps and thanks for your comment and I am glad you liked my tutorial.
Hi IPAPC Absolutely. Have a look at my Conditional Formatting Excel 2007 tutorial. This will give you desired colour result. Simply select the cell range that you require the colour conditions for, enter the formula in the first cell and copy down. If you have any difficulties just let me know. Delighted I could help
Hi Karamveer the number 2 in the formula instructs Excel to go to the 2nd column in the vlookup table. The 2 is representing the reference to the 2nd column on the table.
Hi Hasiqin, Check your formula and your cell addresses to ensure they are correct. Check that your Vlookup table is sorting in Ascending order. Without knowing what you are working on I can't comment any further. All the best.
Hi daeser1 I have made a video in response to your query. You will find it on my youtube channel stepbystepbymiriam and its called Absolute and Relative Cell Reverences.
Thank you so much. I also just stuck up with this problem for 1hour, then search your video and solve it in 1minute. You are just the best teaching instructor. Thanks a ton.❤
Thought338 you are so welcome. I am delighted that my video helped you. Enjoy Excel! Thank you for leaving your comment.
I have literally been stuck on this problem for my college class for 5 hours and you saved me!
I am delighted that my tutorial saved you Jon C! The Vlookup is brilliant once you understand it. Enjoy Excel and thank you for your lovely comment.
Same here, thank you!!!
FINALLY! My college prof instructions are vague. He didn't mention referencing the cell next to the empty one I am trying to find. You saved me in 1 minute and 30 seconds. Been stuck for hours!
Hi Tara, I am delighed that it helped. Thank you for your lovely comment.
Thank you so much, I was on the internet for long hours just trying to find this, all the other videos explain the entire range with ranking formula, but your tutorial was the ultimate answer to my search. Thanks A lot dear
Maazmujahid You are very welcome and I am so pleased that my video was the ultimate answer for you. Thank you for taking the time to leave your comment.
This is literally so helpful thank you so much!!! I've been trying forever to figure out this problem for my Engineering Computations class!
LADY YOUVE SAVED MY HALF AN HOUR EXCEL PROBLEM! THANK YOU M'AM
You are very welcome Mel aran and I am delighted that my Vlookup tutorial helped you. Enjoy Excel!
Thankyou so much whoever you are. Finally i know exactly what vlookup function for.
Hi Zulfikar, You are very welcome and I am delighed that my Vlookup Tutorial gave you an exact understanding of the function. I am an professional IT Trainer who enjoys helping others learn.
Thank you so much aaple mandad aabhaari ❤❤❤❤❤❤❤
You are most welcome Shaikh Saquib.
You have made this so easy, after me trying for ages to do it! Thank you!
Hi Amanda, I am delighted that my Vlookup Tutorial made it easy for you to learn how to use this formula. Thank you for your lovely comment. Enjoy Excel!
Hi IPAPC,
You're very welcome. Delighted it worked. It’s such a good feature too. Can’t be undone with usual formatting as the condition has to be deleted before it can be removed.
Thanks for the tip! I was looking for vlookup function on a range of values to award grades to students. This made my job easier!
You are very welcome Kahate. I am delighted that I have made your job easier. Easier is always good! Keep safe and thank you for your comment.
This helped my homework, THANK YOU VERY MUCH!!!
Hi himhim, I am delighted that my video helped you. Thank you for leaving your comment.
Thank you! I was looking for guides online to do this but I couldn't figure out how as I'm quite new to excel but this video has saved me, thank you. You explain really well :)
+Ellulaith // Hi Ellulaith, I am delighted that you found it explained really well and that it saved you :) thank you for leaving your lovely comment.
The best video for me! Thank you for your very clear explanation.
Rhaglen, thank you for your lovely comment and I am delighted that you found my tutorial very clear.
Thank you very much. You explained the function really clearly.
Steven, thanks so much for your lovely commnet. I am delighted that you found the tutorial on Vlookup really clear.
Thank you this really help me I was trying to figure out this two days now
Thank you!!!!! You save my time😅.
Its very helpful
Delighted that I could help you Moustafa. Thank you for leaving your comment. Enjoy Excel!
This was great! Thank you. I was having trouble understanding until I found this.
+Rocket To Mars Hi Rocket, I am delighted that you found my Vlookup tutorial easy to understand. I appreciate your comment thank you.
Thank you so much I have been struggling with this I have been stuck on a college problem for hours
Keen you are very welcome and I am delighted that my tutorial helped you with the understanding you needed. Thank you for your lovely comment. Good Luck with college.
Thank you so much for your Video. This is really a Great help and my query has been resolved.
Hi M. Danish. I am delighted that my VLookup Video helped you to resolve your query. Thank you for your comment.
Thank you so much, this cleared so much confusion!
Hi Swan Auto47, I am delighted that you found my tutorial clear. Thank you for leaving your comment.
hey i just finished my project..yhu saved a lot of tym. thanx again. =D
You are heaven sent!
Aw thank you Nikki for your lovely comment. Enjoy Excel.
THIS WAS SO HELPFUL! I'M A BUSINESS STUDENT :)
I am delighted that you found my Demo so helpful. Best of luck in your studies.
Thanks so much. Helped me with my marking.
You are most welcome Dilip and thank you for your lovely comment.
Excellent tutorial ma'am!
Thank you Gloystar. I am delighted that you found my tutorial excellent. Enjoy Excel!
You are amazing, thank you for this!
Thank you Yulia and you are very welcome. Enjoy Excel!
Miriam,
I have one more question. I have rankeda table of scores and they appear as 1,3,2,5,6,7 etc and I wanted to show 1st, 2nd and 3rd at the side of the table to make it easier to see medal winners at a glance - if you can understand what I mean, can you assist.
Thank you, Neil
Thanks alot for the helping video
You are most welcome King. I am delighted that you found my tutorial helpful.
This worked perfectly - Thank you for the help
I've been suffering in this program and now I understand
King, I am very happy that I helped to end your suffering and delighted that my tutorial helped you! Enjoy Excel.
hi..your video was a great help to me. thanx a lot
THANK U VERY MUCH! UR TUTORIAL HELPED ME A LOT!! (Y)
why i have N/A error ?? my problem is to say "fail(note from 0--10),pass(10--12),good(12---16),excellent(16--20)" after finding the average if a student,but still have the N/A error.. how to fix ?!
Hi George, N/A in Excel Vlookup means that you have an error. It means Not Available. This is usually displayed when Excel can't find the look up Value. To rectify, make sure you have your lookup table like the one in my video. Do not use used the parenthesis in your table. in the second column put in the the words for each grade besidee the relevent number. Enter 0 for the 'fail' option. Then select the entire lookup table and sort it into Assending Order before you input your Vlookup formula. I hope this helps.
Thank u tons 🎉
this is so helpful, thank you
You are very welcome Jullianne. I am delighted that you found my tutorial helpful. Thank you for leaving your comment and good luck with Excel.
this was very helpful! :) thank you
You are very welcome D Chedid and thank you for your lovely comment. Enjoy Excel!
ur a savior
Hi Ali, I am delighted that it helped you. Thanks for your comment.
Thankyou so much it helped alot.
Abbas you are most welcome and I am delighted that my video helped you.
I have done the same thing as what you’ve done buh I’m not getting the right grade against the total marks
@debbiesmith8778 Hi Debbie Here is a few things to check: 1)Ensure that your Vlookup Table is sorted by Ascending order by the first column, 2) Ensure that within your formula that the Vloopup Cell range is made Absolute - that means it has dollar signs for the beginning table cell and dollar signs for the ending table cell 3) Make sure that all comma etc are correct within the formula. I hope this helps you.
Miriam, your video has been a massive help - 1 question. Is it possible to colour code the value ast is returned, eg: A might have red text, b yellow, c blue and so on. This would make it easier on me to see the grade at a glance. Thank you
Please explain the significance of using the absolute function (F4).
Agar f4 press karenge to humara cell fix ho jata h to jab hum formula wale cell to drag karte hai to wo drag nahi hota jese ki agar a2 cell mai 2 likha hai aur b2 cell aura3 m kuch value aur jab hum multiplied karenge to a2 bhi niche ki tarf drag na ho isliye
Hi IPAPC
I have created a video in response to my understanding of your question Neil. It’s called Excel IF Function for scores. I hope it helps. If not, take a look at my response to Jay Ai’s query as this may also work for you. Alternatively you could just set up a Vlookup table with the scores one side and ranking on the other and then just input a Vlookup formulain the cell range where you require the results.
Once again sorry to bother but, I really don't know what you mean by click f4. Here my laptop is lenova and mine f4 is not showing same result as your. So their I was struck. I can't move on. Cause I was not able to get a result
Hi Tashi, The F4 Function key on your keyboard will make Excel 'cycle' through different types of cell references when you are inputting a formula. On your Lenova Laptop you have a Key Fn (usually on bottom left), Press this Fn Key as you press F4 Function key on the top row and you will get the same result as my tutorial. Each time you hold the Fn Key as you press the F4 Function key, Excel will present you with different cell reference type as my tutorial demonstrates. I hope this helps you.
@@StepbyStepbyMiriam thank you
Super duper! Many thanks.
You are very welcome. Thanks for your comment.
Hello S Miriam,
I have a question. In your tutorial teaching VLOOKUP function version 2010. Does it work the same for Windows 7? Reason I am asking is because the grade chart will not pop on windows 7. I was wondering how will I grade if chart if it does not come up? Truth be told...I am confuse!
Best Regards,
Margaret
Hi Margaret,I have not used a chart for the Grades reference area. I simply typed this information into the spreadsheet and then just applied green highlight to the area. For example, I decided anyone who scored between 55% and 59% was awarded D- and so on. Ensure that you do something similar. You then use your Grades area cell range as your Vlookup table in your formula.The VLookup is a formula and will work if the correct formula and cell references are used. I hope this helps. (Windows 7 is only the computer's operating system Margaret)
Hi Ahmed, delighted it helped and you're welcome.
hi..can i ask for your help? i have a problem with excel.. i solve grades but the excel has a different result from my calculator.. how can i match the result of my calculator to my excel grade sheets? :( i hope you can help me..
Superb
Thank you Allah Bux. I am delighted that you found my tutorial Superb! Keep safe.
Hi Ahmed, delighted I could help and good luck with your project.
thank you so much
You're welcome Zachary. Delighted that it helped
Thank you so much for your tutorial, yours was the easiest to understand.
Hi Lorenzo you are very welcome and I am delighted that you found my tutorial the easiest to understand in the Vlookup. Thank you for your commnet.
Hi IPAPC
I have created a second video in response to your ranking question (just in case I misunderstood your query!) It’s called Excel Rank Formula (on stepbystepbymiriam). It shows how to create a ranking for scores with an Excel Formula. Good Luck with all.
thank you queeen
You are very welcome Eddie.
Hi Jay Ai
If you are using the Vlookup technique to achieve your grades then you may need to have a look at my Vlookup with False video on as this only allows for exact matches. I also have a nice little video called How to calculate percentages for Exam grades in Excel. You could also enter an IF formula such as
=IF(A1
Nice tutorial!! .... Btw why is it that when i write the grade chart upside down like starting from 100-60 downwards it doesnt work the same way 🙁
Nice Question nishant!
Vlookups can only handle data that is sorted in Ascending order. If the data in your Vlookup tables is not sorted in ascending order, then Vlookup may return an incorrect result. Also, Vlookup, cannot handle black cells or errors in the Vlookup table either, as it may return incorrect results. Hope this helps and thanks for your comment and I am glad you liked my tutorial.
@@StepbyStepbyMiriam ohh😯...Thank you very much once again!
You are most welcome.@@nishant7112
THANK YOU!!
I don't know what you refer to f4
Very good
Thank you KFBL. I am delighted that you found my Tutorial Very Good.
Thanks mam🎉❤
@Moviesshor You are very welcome. Thank you for your comment.
Hi IPAPC
Absolutely. Have a look at my Conditional Formatting Excel 2007 tutorial. This will give you desired colour result. Simply select the cell range that you require the colour conditions for, enter the formula in the first cell and copy down. If you have any difficulties just let me know. Delighted I could help
Best!
thanks
You are welcome Ben.
Thank you
great tutorial
Thank you Danual.
I dont understand why she put 2 after the last comma in the formula @2:15
Hi Karamveer the number 2 in the formula instructs Excel to go to the 2nd column in the vlookup table. The 2 is representing the reference to the 2nd column on the table.
why do i get N/A again and again :(
Hi Hasiqin, Check your formula and your cell addresses to ensure they are correct. Check that your Vlookup table is sorting in Ascending order. Without knowing what you are working on I can't comment any further. All the best.
THANK YOU
Most welcome WorldWide and thank you for your comment.
great
Thank you Charles.
Hi daeser1
I have made a video in response to your query. You will find it on my youtube channel stepbystepbymiriam and its called Absolute and Relative Cell Reverences.
100% for an A. Seems a bit harsh!
You're right Family Burrows. It should be 100% and a trip to Ireland :)
BAKWAS VIDEO VOLUME BHI NAHI RAKH SAKTA HA KYA BE
Ní Thuigim :)
Thx
You are very welcome