medium10 pts · first answer countsexcel-modelling

Two-way lookup in a grid

A grid B2:M20 has products down the rows and months across the columns. Which formula returns the value for the product in P1 and the month in P2?

=INDEX(B2:M20, MATCH(P1, A2:A20, 0), MATCH(P2, B1:M1, 0))

A.It returns an error because INDEX accepts only one MATCHB.It returns the value where the matched row and matched column meetC.It returns the sum of the whole row for P1D.It returns the position number, not the value

Discussion 0

Join free to post in the discussion.

Two-way lookup in a grid

Discussion 0

Related questions