Multi-Function Equation Using LOOKUP, VLOOKUP, MATCH, INDEX?

Hello All,

This is hard to articulate but here goes……I need a formula that can do the following:

Data Inputs with Examples from Sheet 1:

Body Weight: 166.5 (Already have this LOOKUP formula that selects the most current weight from a series of weigh-ins)
Exercise Name: Incline Push Up
Exercise Height #: 3 (= 20 inches)
Unit of Measure Codes: W or T or J or B or P (All 5 of these designate the exercise is a bodyweight exercise instructing the formula to either utilize body weight or a % of it; the only remaining code, R, not associated with a body weight exercise would allow indirect input of a barbell weight referenced from another cell on Sheet 1)

From an Array in Sheet 2:

I have already plugged in all the data. Key is that formula must recognize the exercise name on sheet 1

Formula Outputs in Sheet 1:

Exercise Weight: 82 (166.5 x 49%; which is already calculated in the array on Sheet 2)

Thank you,

Patrick