View Single Post
  #6   Report Post  
MikeY
 
Posts: n/a
Default

D1: {=INDEX(C$1:C$4,MATCH(1,(A$1:A$4=A1)*(B$1:B$4=B1), 0),1)}

Your wrong formula must be equivalent to;
{=INDEX(C$1:C$4,MATCH(1,(A$1:A$4=A$1)*(B$1:B$4=B$2 ),0),1)}

--
Mike

wrote in message ...