I am trying to create a formula for a series of cells to calculate the MACRS
depreciation expense for each year of the class life. I have tried using the
VBA function with a vlookup table and can't quite get the formula to work.
The table has 3 columns: A for years 1-8, B for class life 5 and percentages,
and C for class life 7 and percentages. My template has the cost of the
asset and class life for that particular asset. I have tried
VBA(vlookup(F4_cost of asset, 0_for no salvage value, F7_for class life,0_for
start period,1_for end period,2_factor). This does not use the vlookup table.

I'm confused as to how I can make this work with my table.

Any help would be greatly appreciated.

Thank you.