Get Intersection value given column header and row header

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

How will I get the intersect value in an excel table given the row header
and the column header.
ex.

When I type in a A1: 1.5 and in A2:4

1.1 1.5 1.7 1.0
2 23 4.5 2 4
3 5.6 2 1 7
4 9.2 1 3.1 5.3

then it should return is 1.

Thanks so much!
 
One way:


Assume the table is in J1:N4:

=INDEX(K2:N4,MATCH(A2,J2:J4,TRUE),MATCH(A1,K1:N1,TRUE))
 
Back
Top