Excel Match and Index - Sort by define values

[Eugenio1991]

Good Day All ,
Need Help , Im trying to write a formula that will return sorted values base on two criteria, currently working with one . Example is below,

Data is from Sku to Ranking . Formula is written on the Answers line..
i need the formula to return the values per "PK" line base on the ranking given.

Current formula i use is "=IFERROR(INDEX($A$3:$A$250, MATCH(0, IF("Pk10Y"=$AF$3:$AF$250, COUNTIF($AJ$14:AJ22, $A$3:$A$250), ""), 0))," ") but only work for the Pk criteria and need to add the ranking.

any help if welcome .
Thank You.


[TABLE="width: 1274"]
<colgroup><col><col><col><col><col span="2"><col><col span="2"></colgroup><tbody>[TR]
[TD]SKU [/TD]
[TD]Description[/TD]
[TD]PK Line[/TD]
[TD]Ranking[/TD]
[TD][/TD]
[TD][/TD]
[TD]Answers Line 1 [/TD]
[TD]Answers Line 2[/TD]
[TD]Answers Line 2[/TD]
[/TR]
[TR]
[TD]75069115[/TD]
[TD]Org Baby Kale 100%, 6X9 oz, BIL Clam, og[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]75069415[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]75069215[/TD]
[TD]Org Baby Kale 100%, 6X9 oz, SPEC Clam, og[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]75069315[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]75069415[/TD]
[TD]Org Baby Kale 100%, 6X9 oz, SPEC BIL Clam, og[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]75069115[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]75069315[/TD]
[TD]Org Baby Kale 100%, 6X9 oz, Clam, og[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]39000017[/TD]
[TD]Org Baby Spinach, 6X1 LB SPEC BIL Clam, og[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]39000006[/TD]
[TD]Org Baby Spinach, 6X1 LB SPEC Clam, og[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]39060315[/TD]
[TD]Org Baby Spinach, 6X1 LB BIL Clam, og[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]39061615[/TD]
[TD]Org Baby Spinach, 6X1 LB Clam, og[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]