Pull values using Excel LOOKUP Function

[bjnockle]

Looking for LOOKUP Function formula to extract values from F4:F102 of sheet named Outcome into I4:I19 if condition in H3 is satisfied. Sample file attached.

Cannot get this formula to work

'=LOOKUP(INDEX(1/((H$4=$B$4:$E$102),INDEX($B$4:$E$102,,MATCH($H$3,$B$3:$E$3,0)),$F$4:$F$102)))

.

Desired solution:

Apple	Pull
12.0%	1%
9.0%	1%
43.0%	16%
7.0%	1%
1.0%	1%
6.0%	1%
41.2%	7%
41.5%	9%
26.0%	1%
45.2%	27%
40.9%	6%
42.8%	15%
50.0%	51%
47.8%	40%
59.6%	99%
59.2%	97%

Thanks

[Root_]

Maybe

=IFERROR(LOOKUP(H4,INDEX($B$4:$E$102,0,MATCH(H$3,$B$3:$E$3,0)),$F$4:$F$102),$F$4)

[bjnockle]

Root_ : Excellent solution. Works like a charm. Thanks.

[AlKey]

Or this

=IFERROR(LOOKUP(H4,B$4:E$102,F$4:F$102),F$4)

[bjnockle]

AlKey: as always, excellent solution. Thanks for the rep.