Excel Index-match-ception

Consider the above Excel sheet. What will

=INDEX(A1:D4,MATCH("B",A1:A4,0),MATCH(3,A1:D1,0))

and

=INDEX(A1:D4,MATCH("B",A2:A4,0),MATCH(3,B1:D1,0))

return?

×

Problem Loading...

Note Loading...

Set Loading...