Hello there

I need a lookup funtion to find a year to date figure, had a look
through but cant find one to suit.
Spreadsheet looks like this:

1 2 3 4
Jan Feb Mar Apr
10 15 20 18

I have a cell on the sheet stating the period number (1-4) and i need a
function to look up the year to date fugure for that period (ie period
3 would be 45). Function i was trying to use was:

SUM(HLOOKUP(1,'Detailed OH - TSC 06-07
Budget'!$G$8:$R$188,8):HLOOKUP($R$3,'Detailed OH - TSC 06-07
Budget'!$G$8:$R$188,8)) The lookups work fine on their own but not when
i try and sum them.

Any ideas would be fantastic!

Cheers

Brian