View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Scorcel Scorcel is offline
external usenet poster
 
Posts: 1
Default Get Intersection value given column header and row header

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!