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.
|