Sorry, I missunderstood...

Does this help:

Formula: copy to clipboard
=FORECAST(A2,OFFSET(C2,MATCH(A2,C:C,1),1,2),OFFSET(C2,MATCH(A2,C:C,1),,2))