This is an ARRAY formula that must be entered using ctrl+shift+enter. If
same sht, remove sht reference

=MIN(IF(Sheet11!A2:A22=a1,Sheet11!B2:B22))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"tt" wrote in message
...
I have a list of products with the cost of each (each product appears on
the
list multiple times with varying costs). I need to create a formula that
will
pull the lowest cost for each product into another existing list which
displays all the products once.

Any help is appreciated.