View Single Post
  #2   Report Post  
John Michl
 
Posts: n/a
Default

You could use a combination of Match and Index. Assuming your table is
in the range A1:D4 (where A1 is blank and D4 = 9), the following will
work:

=INDEX(B2:D4,MATCH("A",A2:A4),MATCH("E",B1:D1))

- John