Question: B D E E F G 1 2 3 4 5 6 7 1x 2x 3x 4x 5x 1x 1 2 3 4 5 2x
B D E E F G 1 2 3 4 5 6 7 1x 2x 3x 4x 5x 1x 1 2 3 4 5 2x 2 4 6 3x 3 6 9 4 8 12 16 20 5x 5 10 15 20 25 12 15 10 The formula = INDEX(B2:F6, MATCH("4X", cell with the red box LO), MATCH("3" _O)) would give the result of the A2:A6, B1:F1 D2:06, B5:F5 B1:F1, A2:A6 B5:F5, D2:06
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
