Finding out which item has the most and the least cost

The scenario:
I have a table with 3 columns, these are item name (A), item quantity (B), cost per item (C), and cost of items (D). The last quantity is just a product of B and C.

What I want to do:
I want to find the name of the item that has the the least cost per item (C) and the most cost per item and put the name of the item and cost into a cells. I also want to find the least cost of items (D) and the most cost of items and put the name and the cost into cells.

What I have tried:
CELL("address", INDEX(C2:C6,MATCH(MIN(C2:C6),C2:C6,0),1)) gives me the exact cell location which has the least value, in this case if I use this formula in a cell it shows the following in it:
$C$4

which is correct. I than tried to use this with the offset formula as in OFFSET( CELL("address", INDEX(C2:C6,MATCH(MIN(C2:C6),C2:C6,0),1)) ,0,-2) but Excel gives me an error. What is the correct way to do this?

Also suppose that there are multiple items that have the same minimum/maximum cost associated. How do I find out this is the case and how can I find how many items have this minimum/maximum cost, besides this how can I find out the item names in this case and put them into a seperate sheet using excel formula/functions?

Yes, it did the trick. I still don't know what is wrong in my previous approach though as CELL("address", INDEX(C2:C6,MATCH(MIN(C2:C6),C2:C6,0),1)) returns coordinates of a cell and OFFSET can accept those coordinates and add an offset value of -2 to it to get me the item name. OFFSET does infact accept things like C4 and $C$4, but in this case it didn't!

Anyway, how to find if multiple items have this same low cost, count them and put them all into a new sheet inside Excel?

Thanks