medium10 pts · first answer countsexcellookupsindex-match

Lookup by row and column

Products are in A2:A50, month names in B1:M1, and sales in B2:M50. Which formula returns sales for the product in P1 and month in P2?

A.=INDEX(A2:A50,MATCH(P1,B1:M1,0),MATCH(P2,B2:M50,0))B.=INDEX(B2:M50,MATCH(P1,A2:A50,0),MATCH(P2,B1:M1,0))C.=MATCH(INDEX(B2:M50,P1,0),INDEX(B1:M1,P2,0))D.=VLOOKUP(P1,A2:M50,P2,FALSE)

Discussion 0

Join free to post in the discussion.

Lookup by row and column

Discussion 0

Related questions