Creating an array of matches to pass to a forecast function??

[DT112]

Hi,

I am trying to use a forecast function. For it to work I need to provide a list of known x and y values. (Easy so far).

The problem, I am having is that my list of x,y values contains many things I don't want to include.

I want to be able to have a forecast function I can drag down that is checks if the criteria adjacent to it is in the data set, if it is, add the value into the array. Do this for each value in the whole data set, so for each criteria, it products a different forecast inputs.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Campaigns[/TD]
[TD]X Values[/TD]
[TD]Y Values[/TD]
[TD]Forecast[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]50[/TD]
[TD]53[/TD]
[TD]This needs to forecast x any y values only if the campaign is equal to 1 in this case, the rest are ignored.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]10[/TD]
[TD]32[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]23[/TD]
[TD]31[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]34[/TD]
[TD]22[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]13[/TD]
[TD]31[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]23[/TD]
[TD]43[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]44[/TD]
[TD]32[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]54[/TD]
[TD]55[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]23[/TD]
[TD]21[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[DT112]

bump

 

[DT112]

bump