Find Max and Min based on cell reference(s), display corresponding value

MY CURRENT FORMULAS/TABLE FORMAT:

Please Login or Register  to view this content.

(Displays the Price for the most expensive Item of the Type entered in K16.)

Please Login or Register  to view this content.

(Displays most expensive Item in table.)

(A:A is Type column)
(C:C is Item column)
(D:D is Price column)
(H:H is basically a True/False column)
(K16 is the Type I am telling it to look for)

FIRST QUESTION: How can I modify the formula to show that newly-found Price's corresponding Item (C:C)?

SECOND QUESTION: How can I modify the formula to show the Item (C:C) that matches multiple criteria (A:A column matches K16, H:H matches "x")?

THIRD QUESTION: How can I modify the formula to show the Price (D:D) that matches multiple criteria? (A:A column matches K16, H:H matches "x".)

NOTE ON ATTACHMENT: The GREEN cells are the ones I am trying to populate.

(P.S. I used this helpful thread to get to this point: http://www.excelforum.com/excel-misc...reference.html)

Not entirely sure I follow the last two requirements - is "nine's" meant to be a partial search of Name ?

L4:
=MAX(IF($H$2:$H$3000="x",$D$2:$D$3000))
committed with CTRL + SHIFT + ENTER

L5:
=MAX(IF(($H$2:$H$3000="x")*($A$2:$A$3000=$K5),$D$2:$D$3000))
committed with CTRL + SHIFT + ENTER

L6 & L7 are as above merely replacing MAX with MIN.

You could technically use INDEX, eg "for most expensive item I own":

=INDEX($C$2:$C$3000,MATCH(1,INDEX(($H$2:$H$3000="X")*($D$2:$D$3000=$L4),0),0))
(not an array so commit with ENTER as normal)

Hopefully you can work on the remainder... of course if you have multiple products matching criteria the above will return only the first matching item.

Awesome! We're getting so close!

=INDEX($C$2:$C$3000,MATCH(1,INDEX(($H$2:$H$3000="X")*($D$2:$D$3000=$M4),0),0))
This is working to find the most expensive item that the user owns in the list and display the name of the item, rather than the price.

Now I just need to figure out:

(1) how to find the most expensive item that falls within a specified "Type" in the list and display the name of the item, rather than the price.

(2) how to find the most expensive item that the user owns AND that falls within a specified "Type" in the list and display the name of the item, rather than the price. <--This is already working, woohoo!