Can anyone make this formula for me, thanks :(

[finnkie]

theres 2 sheets YORKY and MILK
im currently in sheet MILK writing formula that
if value in sheet MILK Column C row 4 found in sheet YORKY column BH row 8 until column BJ row 10 then the final output is row 5 where they found the match
for example the value in sheet MILK column C row 4 is "TF.005.MK" then it searches inside sheet YORKY column BH row 8 until column BJ row 10 then the final value output is POU CHEN FACTORY

 

[vletm]

finnkie​

Please, check/verify that - where should find TF.005.MK?
I could not find it.