MACRS depreciation formula

[Maxine]

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.

 

[Tieske]

Can you be more specific, I'm not getting whatever it is you're trying to do
here

vlookup generally can lookup a value in the most left column and then
return a value in one of the next columns.

 

[Maxine]

I actually figured it out (amazing). I needed to use an HLOOKUP. Thanks
anyway for the response.