Non Array formula to pull values if conditions met

Formula I:
Looking for non-array formula to extract values in sheet named Product into B5:M8 of sheet named LookList and Outcome if conditions in B2 and C2 in Product sheet are met. Sample file attached.

Region	Product	Ar	Br	Cr	Dr	Er	Fr	Gr	Hr	YTD	YET
North	Apple	-	-	-	-	-	42.1%	33.1%	31.1%	40.2%	42.2%
North	Banana	-	-	-	-	-	32.4%	35.4%	38.4%	41.4%	41.4%
North	Coconut	-	-	-	-	-	34.7%	36.7%	38.7%	40.7%	40.7%
North	Mango	-	-	-	-	-	37.0%	38.0%	39.0%	40.0%	40.0%

Formula II:
Looking for non-array formula to extract values in sheet named Product into B14:M29 of sheet named LookList and Outcome if condition in B11 in product sheet is met. Sample file attached.


Formula III:
Looking for non-array formula to extract values in sheet named Product into B38:M45 of sheet named LookList and Outcome if conditions in B35, C35, and D35 in product sheet are met. Sample file attached.