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.

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" wrote in message
...
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.

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

"Tieske" wrote:

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" wrote in message
...
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.