forecast func

[beng986]

hello,

im trying to use the forecast function but not all of my inputs are next to each other in a row. is there a way round this?

example

1	2	3	4	5
2	3	4	5	6

<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>

what i would like is

=forecast(6,(6,4,2),(5,3,1))

so i dont want to use the second and forth colomns.

thanks

 

[Robert Mika]

Try:
=FORECAST(6,{6,4,2},{5,3,1})