Learn how to Vlookup the smallest value in a Excel database by using a combination of the Min formula with the Vlookup formula. If you want to find the Lowest value in a data set 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.
