CODEWITHSUNDEEP
excel
Heifetz_Fan
Heifetz_Fan

Reputation: 459

Excel return address for future calculation

I want to perform some calculation based on a time-series in Excel. The logic of the calculation is attached in the plot below: enter image description here

I want to perform the calculation on a time series from the 1st date in time-series to the "Until" date. How do I let Excel automatically replace "C14" in the calculation cell with the correct address?

I used the function ADDRESS(MATCH(F2, A:A, 0), 3) to get "$C$14". However, I couldn't use this function to replace C14 in the calc() function, because it has extra "" quotes around it. How do I get rid of the quotes "" to fill in?

Upvotes: 0

Views: 28

Answers (1)

Gowtham Shiva
Gowtham Shiva

Reputation: 3875

You can get it done using the INDIRECT function,

=INDIRECT("C"&MATCH(F2,A:A,0))

Assuming your until date is present in cell F2, the indirect formula will return the reference. You can add this to your calc formula.

Upvotes: 1

Related Questions