However, this doesnt work when I try to put the formula in another worksheet, I use:

=FORECAST(AY8,OFFSET('MID-SWAP Curve'!$C$2,MATCH(AY8,'MID-SWAP Curve'!$C$3:$C$36,1),1,2),OFFSET('MID-SWAP Curve'!$C$2,MATCH(AY8,'MID-SWAP Curve'!$C$3:$C$36,1),,2))

Somehow the match function gives N/A

Ideas?