Learn how to Vlookup the smallest value in a Excel 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.www.myelesson.org If you want to find the Smallest like the lowest sales from say the total sales of a year or lowest marks of student out of all the students in the class then Vlookup can find the lowest value in excel for you. In excel the lowest value can be calculated with the Min formula and the vlookup can be used with Min formula to find the smallest value. The min formula identifies the lowest value and the vlookup formula locates that value for you and brings it where ever you want. 10 Most Used Formulas MS Excel
