Lookup and return multiple values sorted in a custom order

[alirezae90]

I want to use the function in this link (

https://www.get-digital-help.com/2013/12/13/lookup-and-return-multiple-values-sorted-in-a-custom-order/

) but the only difference is that I want mine in descending order not ascending order. How do I modify this function to do that?

This is the function:

=INDEX($D$3:$D$14, MATCH(SMALL(IF($G$2=$B$3:$B$14, $C$3:$C$14, ""), ROW(A1)), IF($G$2=$B$3:$B$14, $C$3:$C$14, ""),0))

 

[gaz_chops]

You have already asked this!

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...der-based-next-column-values.html#post5210851

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).