Please see the attached ods file with two sheets for the problem.
The problem is, when a name is selected in dropdown at B17 : ANLYS.ods.
To have all the corresponding STRIKE_PR of that particular name filled up in the column D beginning at D17 after matching OPTSTK, CE, 30-May-2019.
To have only STRIKE_PR of top three highest OPEN_INT corresponding to that particular name. filled up in the column L beginning at L17 after matching OPTSTK, CE, 30-May-2019. (OPEN_INT are in column H in yday sheet)
As you can see, I tried with INDEX and MATCH function, but it is showing only the first matched STRIKE_PR ignoring the rest. Perhaps it requires a different combination of functions.
I hope someone can help / guide me.