Using variable ranges for spline function

[spacely]

Hi everyone,

I am using the spline function like this:

=Spline(A26:A31,B26:B31,A28,FALSE)

but want to look up and construct the ranges based on variables, something like:

=Spline(ADDRESS(MATCH(D1,A4:A78,0)+3,1):ADDRESS(MATCH(B1,A4:A78,0)+3,1),ADDRESS(MATCH(D1,A4:A78,0)+3,2):ADDRESS(MATCH(B1,A4:A78,0)+3,2),A28,FALSE)

Excel 2010 is complaining about that. Is there a simple way to make the ranges variable?

Thanks for helping!

Dave

 

[shg]

Try replacing ADDRESS(MATCH(D1,A4:A78,0)+3,1): with INDEX(A:A, MATCH(D1,A4:A78,0)+3): and similarly throughout.

 

[spacely]

Thanks, that did the trick.

 

[shg]

You're welcome.