Vlookup in Excel with Min 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 in Excel with Min Formula






In this video you can learn how to lookup the least value in a database by using a combination of the Min formula with the Vlookup formula. For more training videos and to download the training file shown in the video visit www.myelesson.org This Excel tutorial has been created to help you learn microsoft excel online. On http://www.myelesson.org you get excel help and online file download facitity. This video lesson covers the entire topic in simple and easy to understand step by step approach.
Hello Everybody Welcome to Excel Made Easy I’m your excel guru. Today I’m going to tell you new formula of Excel. Well rather it’s the combination of two formulas, it’s the Vlookup formula with the Min formula, The MIN formula. As we know the MIN formula actually finds out the lowest value from a given range. Let’s take this example, these are the marks of few students in English, History, these are the total marks that can be possibly achieved and these are the marks that have been achieved, these are the percentages and these are names of students who have achieved these marks. So let’s see if I want to find out what is the minimum, who is the person who has scored the least number of marks then I would have to first of all find out which person is having, which of these is the lowest number and then what is the corresponding name to this. Correct! That’s the way. Well then that requires two formula the first one is MIN it says number, number 2 that means you can select a range and close it. So 116 so this is 116. Now the corresponding name is Mike. So we need to find out in a single formula how to combine these two things. So that can be done using Vlookup with Min.

We’ll see how we do that. Well I am assuming you know how to place a Vlookup. So in this lookup value I am going to replace the lookup value with the formula which is MIN and I am going to open the bracket again and now I am going to define this range. OK. Excel find out the lowest number from this range and then from this table array which is highlighted over here, from this table array go to column index 3, 1, 2, 3. I want to find this name and give me the name of the person who is corresponding to the lowest result and I press enter and here is the answer Mike See, Isn’t it easy. What we did was, See we will check over here. We placed the Vlookup formula with the look up value we used the Min formula to find the lowest figure the lowest number from this range then we ask Excel to dense search this lowest number in this table array to correspond with a corresponding name that is how we got it So this was the formula for today Vlookup with MIN.

The excel file shown in this video is available for free download on my website, you can download it from there. Until the next formula, until the next video. 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