Data Table needs Inflated Value of Base cost x Inflation Factor from 2nd Table 1

[BFClem]

Condo Assoc. future replacements budget:

Table 1 (elements)
Element, year of replacement, # years away, Current Cost, est. future cost.
roof1 2026 4 25000 ?
deck2 2028 6 7000 ?

Table 2 (assumed price inflation)
year0, year1, year2, year3 year4
0, 5%, 5%, 2.5%, 2.5% inflation
1 1.05 1.1025 1.1300625 1.158314063

Assume roof1 needed in 4 years, and the inflation table shows a multiplier in year 4 of 1.158314063

formula that reads # years until replacement, and based on that, plant the est. future cost in the table? (Current cost x inflation multiplier based on years away)
Or, another method to tackle this table which will be pivoted for cash flow needs.

Thanks

 

[SkipVought]

Hi,

Is there a question?

Suggestions:

1) use Structured Tables Insert > Tables > Table
2) your lookup table is not structured to be useful in Excel
3) do not include years away in you table, cuz that changes EVERY YEAR.

Having done that in my workbook, here's a simple solution:

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

 

[BFClem]

Thank you for the formula, Skip, you found and answered the question, now I have some work to do!

BFClem

 

[Andrzejek]

How about a Star for Skip...

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[BFClem]

Thanks, I did click the star before, but I now see the confirmation click that was missed, thanks for pointing it out!

Skip's help was invaluable.

BFClem

 

[SkipVought]

Glad that solved your problem.

I've uploaded my version of your example.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

 

[BFClem]

Thank you again, Skip. Received.

BFClem