I'm sure I'm making this harder than it needs to be, but I can't seem to figure out the simplest way to sort the results of a lookup (INDEX/MATCH) based on a user-selected value from a drop down to make them ordered by a grouping value, a priority value, and then alphabetically.

Training Item Priority Level Priority Order
Learning to Quote 1 - Required 1
Printing a Quote 2 - Suggested 2
Closing the Deal 3 - Optional 1
Next Steps 3 - Optional 2
In Your Spare Time 3 - Optional 0
Making Money 1 - Required 2
After the Sale 3 - Optional 0
Billing 2 - Suggested 1

The sort should be first on the Priority Level, then on the Priority Order, then, if it doesn't have a priority order (the value for those will come over as 0), put them after the ones with a priority order and sort them alphabetically. Sorted, it would look like this:

Training Item Priority Level Priority Order
Learning to Quote 1 - Required 1
Making Money 1 - Required 2
Billing 2 - Suggested 1
Printing a Quote 2 - Suggested 2
Closing the Deal 3 - Optional 1
Next Steps 3 - Optional 2
After the Sale 3 - Optional 0
In Your Spare Time 3 - Optional 0

The Training Item is based on the selection a user makes in a drop down to select their role (this is a curriculum document) and the lookup based on that field is working fine. If you need that formula to handle the rest of this, let me know, but I don't know that it's necessary. I also have 1000 rows with the formulas in them so it will grow to the right size no matter how large the data set is that the user selects, so there will be many rows that result in blank cells.

I have no problem using as many helper columns as needed - I have like 11 today in my not-so-great method - as they will be hidden in what the user sees. I tried adding using COUNTIFS and selecting items that aren't blank and where the priority level is sorted then it's sorted alphabetically and it's messy but it works. Now adding in the ranking, I can't seem to figure it out.

Hopefully the attached simplified version of the catalog will illustrate what I'm trying to do!

Catalog simplified for Excel Forum help.xlsx

Thanks for ANY assistance you can provide!
LG