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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!