All:

I am stumped on this.

I have combed through the archives and cannot find the answer

I need to return the minimum price for an item (where the price is not zero)

Item Price Vendor
Apple $1 Wal-Mart
Apple $2 Target
Apple Sears

I need the formula to return $1.

=IF(MIN(VLOOKUP("Apple",B2:B4,FALSE)))

is definitely not working.

Thanks,

Doug