View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BZeyger BZeyger is offline
external usenet poster
 
Posts: 31
Default Finding a value in a cell matching up with a column/row

I am tring to figure out how to find a value in a cell. the first Column a
wold consists of values and the first row would be the year. I need to find
the value that corrospondes with teh year.
For Example

2005 2006 2007 2008

Price 2 3 4 5

Rate 4 5 7 2

Total 8 15 28 10

I need to find the value of the Total in 2007

How can this be done? either by code or by formula.