Refer Back to the Cell Returned by Address Function

I'm calculating an XNPV and I have the values and dates changing, so I've used Address and Match to return the start and end cells for the XNPV calc...

But I'm getting a Value error, and I think it's because the XNPV doesn't recognize what the Address function is returning... Is this right?

Basically, I want the XNPV function to refer back to the cell that Address returns... is that possible?

Hello
The ADDRESS function only returns a text reference. For Excel to use it as an actual range reference you need to place it within the INDIRECT function. For example, to Sum $A$1:$A$5:

=SUM(INDIRECT(ADDRESS(1,1)&":"&ADDRESS(5,1)))

Hope this helps.
DBY