Try this array formula** :

=MIN(IF((A2:A4="apple")*(B2:B4<""),B2:B4))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"Huber57" wrote in message
...
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