Vlookup 2 Criteria (ascending order and unique)

Hi

in google sheet, https://docs.google.com/spreadsheets...gid=1836933493

I have 2 sheet, The relevant data sets in those sheet are as follow :
- Top Predicted Stocks by ML sheet, whereas at colomn B there's a 'stock name' (text value), at colomn I there's a 'score' (numerical value) and at colom J there's 'industry category' (text value).
- ML Instruction for the Trading Platform whereas at colomn B is the 'stock name' (text value)

So, I need a formula in ML Instruction for the Trading Platform colom B2 which retrieves text value in Top Predicted Stocks by ML colomn B:B with a condition to get the largest 'score' data in numerical order term at colomn I2:I and the 'industry category' at colomn J2:J it must be uniquely scrapped.

You can refer to a similar formula previously I had :
=INDEX('Top Predicted Stocks by ML'!B:B, MATCH(LARGE('Top Predicted Stocks by ML'!I:I, 1), 'Top Predicted Stocks by ML'!I:I, 0)).

So basically the GOAL, what I need is that, to pick few of the highest scored stocks but they're all must be in a different industry category.

Is this the same question as your earlier thread?

This seems to do what you want. Just needed a small change to your first formula.

Formula:

Please Login or Register  to view this content.

in F2 and copy down.