MS Excel, how to refer to max row number 1

[brianwustl]

Hello,

I am using an add-in tool that uses a formula that looks like this:

=Interpolate($C$1:$C$49, $D$1:$D$49, $F1, ,0)

However, I would like the formula to be able to pick up the last row number (i.e., "49") from another cell.

Do you know how I could do this?

Here would be the pseudo-code, so that you can get a better picture of what I need:

=Interpolate($C$1:$C$($A$1), $D$1:$D$($A$1), $F1, ,0)

Thanks,
Brian

 

[Gavona]

Interpolate($C$1:indirect("$c$"&$a$1).....

Thanks,

Gavin

 

[brianwustl]

Awesome, thanks!

It worked.