Vlookup With Max Formula

This topic has been explained in great detail in the video shown below, to learn this topic just play the video and the notes are mentioned below the video.


Vlookup With Max Formula






Vlookup with max formula
Hello everybody , welcome to Excel made easy , I m your excel guru I have come up & I have brought a new formula today its called Vlookup with Max , It’s a combination of Vlookup & Max , we all know what Vlookup does is , Vlookup looks for specific answer for you based on a criteria given by you and what does max do , max find out the largest number within a given range so how does max work let see = max bracket open and lets find out the highest mark achieved by anyone in English so 99 were the highest marks achieved in English .

Now based on this we want to find out who achieved these marks so we can do it with Vlookup so here are the names of the people lets see how it would be able to pull it up ,so we will copy it over here , I’ll copy the names over here , so now I m going to use Vlookup , Vlookup now something important – bracket open max bracket open select the condition on which you want to select the column or the range on which you want to find out the maximum marks like we are using English so column name English so we are selecting it close the bracket.
Now if you see Vlookup has automatically change to Vlookup over here it shows lookup value that means now Vlookup would be taking in reference the maximum the largest number found by this formula , Now press comma it is asking for table array this is your table array , complete table array ensure that column one is that column based on which you are finding the largest value and then your answer say you are looking for name so the answer would be in column 6 , comma 6 comma 0 bracket close & here is the answer ,Bob has got 99 marks in English , How can he go better than me I ,I used to get better marks than him ,so how can something be better than 99 so why there is something better than 99 it is 99.99 see Excel guru has got the highest marks , so this training file video training file seen in this video sorry the excel file shown in this training video is available for free download on my website
http://www.myelesson.org com you can go to this website I created this by myself , you can go to the training file page and download the training file for free & here are the video playlist , you can watch the videos from here itself
And if you believe that what I m doing is right & the work should be shared with others also then you can click on this link follow on me on Twitter , it will take you to my twitter page , where all you need to do is click on the follow & you will be able to get my tip of the day I do it every day and also you will get to know my new updates also you will be able to share the work & the same I would like you to do or you may choose to also access my facebook page by clicking over here , Excel made easy on facebook & like us over here like me over here and more than that you would I would like you to share the contents with others with your friends and colleagues on facebook because that’s my motto lets share knowledge and on youtube where you are watching this video you can click on subscribe so that whenever a new video is uploaded by me you can get access to it without any cost , free of charge by Youtube , Information and you can share the video with others also
So this is your Excel guru signing off for the day have a wonderful day ahead, happy excel learning








Our Other Services




Read Free Ebooks

myeboook.com

Myebook has 1000's of free ebooks for you. On productivity, health, online income, learning, music and many more, it's free of course!



Buy Excel Course

myelesson.org/product

Become an Excel Guru, Buy the best Excel course. Learn on your mobile, tv & laptop without internet. For COD, Call 9752003788



Create Best Looking Resume

http://www.makecv.org/

At Makecv.org you get to create a amazingly professional looking resume in just 3 steps with our intuitive resume builder!


Download Excel Crash Course


This Excel Crash Course contains the list of topics that cover the most important and used features and formula of Excel . This Excel Crash Course lists 43 major topics in Excel so that you can start using Excel like a pro in the shortest possible time.



Learn Photoshop Web Designing


You can Buy the Photoshop Course to learn Photoshop and start a career in Web Designing and Photo Editing. .



Learn HTML CSS


You can Buy the HTML CSS Course to learn HTML CSS and start a career in Web Designing and Photo Editing. .


Download Full list of Excel Shortcuts


This Excel Shortcuts Complete list is to help you become save time and use Excel like a Master level user. Excel is best used when you know the Keyboard shortcuts because the use of keyboard shortcuts in Excel helps you in completing tasks faster.

I have created a Excel Shortcuts complete list for you to use Excel better, this list has 242 excel keyboard shortcuts which means that it covers almost everything that can be done using shortcuts in Excel.




Full List of Excel Formulas

This is a complete alphabetical list of all the Formula in Excel with a description. You can learn all these formulas on www.Myelesson.org




Convert Numbers to Text in Excel

Now easily convert numbers to Text in Excel with this inbuilt sheet from myelesson.org .  Many times we need the amount in figures to be converted into words. This is a typical requirement for writing checks or any other financial reports. Microsoft Excel does not have standard function available for this requirement. Just download this sheet and then you can convert any number to text in Excel.




List of Most Commonly Asked Excel Questions in Interviews

Here is the list of most asked excel related questions in interviews.  Prepare for this excel questions and you would be able to most of the excel interviews. This list of excel questions covers excel formula, excel analysis, excel reporting, excel charts and more.





Myelesson © 2010 - 2014. All rights reserved.

Do You Want to Become a Expert in Excel ?
Buy The Full Excel Course Now
Enter Your Details & We Will Contact You
Great Choice
Thank You
Ok
Do You Want to Become a Expert in Excel ?
Buy The Full Excel Course Now
Enter Your Details & We Will Contact You
Great Choice
Thank You
Ok