Find 5th highest value in column based on criteria

[trock12]

Let's say I have 3 columns - of which A and B contain multiple records of the name.

Column A = Color
Column B = Manufacturer
Column C = A number

What I'm looking for is if Column A = "Green" AND Column B = "Microsoft", return the 5th highest value in Column C. (which obviously matches my criteria).

If tried MaxIFs, (Large,5), IF(AND(....and I'm missing something!

 

[Marcelo Branco]

Maybe something like this

=LARGE(IF(A1:A100="Green",IF(B1:B100="Microsoft",C1:C100)),5)
Ctrl+Shift+Enter

M.