try this

=SUMPRODUCT((A2:A4=2)*(B1:D1=2008),(B2:D4))

this looks for w/c 2 in A2:A4 and 2008 in B1:D1 and returns the numeric
value at the intersect.

It would be better to make the 2 & the 2008 cell references.

Mike

"Pierre" wrote:

On a worksheet, we have 72 work centers, and charge rates for each
year and each center in a table; going out 12 years.

W/C 2008 2009 2010 etc
1 15.00 16.98 18.10
2 23.98 24.25 26.98
3 11.00 13.85 15.65
etc.


Would like to obtain the rate for each workcenter on another sheet for
the year thats entered into cell A1 in the worksheet.

A bunch of IF statements. . .=IF(YEAR(D14)=2008,TRUE,FALSE) could be
really clumsy as a place to start, as there are 12 years to chose
from, making the formulas particularly messy.

Thoughts?

Pierre