SPILL RESULTS AS ARGUMENT FOR VBA FUNCTION

[demariscal]

I am trying to use the spilled results from a "FILTER" function in a spreadsheet and pass it as an argument to a VBA Function, but it is not working. Please help. Thank you.

 

[demariscal]

=dem_Interpolate(D20,FILTER(RESULTS2!$N$4:$X$4723,RESULTS2!$P$4:$P$4723=$AB$15),6)

I can use the function if I put the spilled results to the side and reference the cell as shown below, but it I would like to keep it all together.

=dem_Interpolate($D20,$AY$20#,6)