In a formula relative to straight line depreciation, I have to cells I need
to fill in with formulas. The first cell requires the first year of the
total useful life of the asset. The acquisition date is taken from a
vlookup. The first cell would be a year's worth of depreciation less one
month.

The second cell requires the next full year's amount of depreciation.
The project requires that when you click on a specific asset, the column
lists all the years depreciation starting with the first year in the first
cell of the column to the last year.

I know this sounds confusing, but can you help?