I'm trying to use VLOOKUP to find lowest value in a small group. The exact sample is below:


A B
1 3.0001 A
2 2.9442 B
3 2.9610 C
4 2.9055 D
5 2.9630 E


The formula I'm using is =VLOOKUP(MIN(A1:A5),A1:B5,1) . I'm trying to get it to return the lowest cost, from column A. If I take out Row 4, it works. But with Row 4 in it, it returns a value of #N/A, I'm guessing from the HELP screen it's because "...lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP returns the #N/A error..."

Sorry, don't get it. Anyone feels like helping a noobie get it thru his skull?

Thanks,
Jim Dixon