Excel Formula Needed

[Ledge]

Good day

I'm looking for a formula that can help with replacement years. Say I buy a Laptop in 2020, and have a replacement criteria in cell C3 that is "3" years.

Thus I will this I will replace it in 2023 2026 2029 2032.....

The formula needs to pull the cost into each Colum for the specific year as I have 300 different items.
A B C D II F G H I J K L

Description Purchace Date Interval Price 2020 2021 2022 2023 2024 2025 2026 Laptop 2020 3 5000 - - - - - - - <colgroup><col><col><col><col><col><col span="6"><col></colgroup><tbody> </tbody>

<colgroup><col><col><col><col><col><col span="7"></colgroup><tbody>
</tbody>

Many Thanks

 

[Aladin Akyurek]

Something like:

=LOOKUP(B2+C2,$E$1:$Z$1)