Return result from two criteria

Hi All,

Hopefully this question has a simple answer.

I have a worksheet with employee names in column A and dates in row 1 (see attached).

I am trying to figure out a formula where if I select an employee and date, the amount for that employee on that date will be calculated.

For example, on the attached workbook if I was to select employee 'Andy' and Date '03-May-2010' the result should be 683.66 which should be returned in cell C32.

Any help would be appreciated.

Thanks

Ben