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