Hello All,

This is a difficult problem to articulate but here goes.....I need to create a formula that can upon entering a value in 1 cell must find a matching value within 3 levels of sorting: GENDER (2 Choices), AGE GROUP (6 Choices) and EXERCISE NAME (Numerous Choices). Then it must auto-populate values in a 65 cell array (5 columns x 13 rows) with column labels.... LEVEL, DESIGNATION, COLOR, GRADE, SCALE and 13 levels (rows). So the trigger value that when entered causing all the other associations to respond is the number of reps performed for an exercise.

Gender
Man

Age Group
50 - 59

Exercise Name Reps Level Designation Color Grade Scale
Push Ups 25 9 Intermediate Blue B- 81%


Thank you,

Patrick