Vlookup on multiple criterias and on different sheets

In a google sheet, https://docs.google.com/spreadsheets...t#gid=93676469
I have many sheets :
1. Top Predicted Stocks by ML
2. ML Instruction for the Trading Platform
3. Portfolio
4. Multiple sheet which are listing Stock prices, whereas the sheet's name are dynamically refers to field B10:B at ML Instruction for the Trading Platform, whereas these sheet's name is same as text in Portfolio B10:B, so the name is not "Stock prices". So To dynamically refer to the sheet with the same name as the text in cell B10 of the 'ML Instruction for the Trading Platform' sheet, you can use the INDIRECT function.

----
At sheet Top Predicted Stocks by ML colomn B is stock name (text value), at colomn F is Target Executing Selling Price (numerical value).

At sheet ML Instruction for the Trading Platform colomn B is stock name (text value), at colomn G is Target Executing Selling Price (numerical value), at colom C is lot (numerical value).

At sheet Portfolio colomn A is stock name (text value), at colomn B is AVG COST (numerical value) colomn C is LAST PRICE (numerical value) and colomn D lot (numerical value).

At each of the "Stock prices" sheet, at P1 there will be stock name (text value), which is same as text in Portfolio colomn B and at colomns L:L there will be 20Days>200Days moving average whereas the field will be stated as either "YES" or "NO".
---------
So I need a formula at sheet ML Instruction for the Trading Platform in colomn I10:I,
that crawls these data :
1. Sheet Portfolio colomn A (stock name (text value)), B ( AVG COST (numerical value)) and C (LAST PRICE (numerical value)),

2. Sheet Top Predicted Stocks by ML, colomn B (stock name (text value)) and colomn F (Target Executing Selling Price (numerical value)).

3. The multiple sheets which are listing Stock prices, each at colomns L2 (20Days>200Days moving average) and P1 (stock name which is same as text in Portfolio B10).
------
Whereas the criterias are :
1. CUT LOSS : when if the LAST PRICE is below 25% of the AVG COST
or
2. HIT TARGET : when if the LAST PRICE is the same as in sheet Top Predicted Stocks by ML colomn F (Target Executing Selling Price (numerical value))
or
3. HIT TARGET (BELOW 5%) : when if the LAST PRICE is about 5%-1% below compared to that of in sheet Top Predicted Stocks by ML colomn F (Target Executing Selling Price (numerical value))
or
4. 20 DAYS MOVING AVERAGE DOWN : when if the text value is "NO" at The multiple sheets which are listing Stock prices at each of the L2 (20Days>200Days moving average)

-----
Then if one of those criteria is met, please return with a text value to specify which one (or more) of those criteria did it met with. But if it did not meet any of the criteria, please leave it blank.

Administrative Note:

YOU SHOULD KNOW THE RULES BY NOW

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Originally Posted by AliGW

Administrative Note:

Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Hi,

I am a little bit confused on what the title should be honestly for this case.
Also, May I know what does it means by explicit and not be generic ?

I have modified it and hopefully it mets the requirement.

Thank you.

Well done! You get rep for helping others, not for helping yourself, but nice try.

Thanks for sharing.

EDIT:

no, the other one has been done by a freelancer I hired. thank you

It wasn't even done by you! Kudos to the freelancer.