I'm trying to come up with a vlookup (I think) formula to carry through purchase amounts of assets on the depreciation schedule. Attached is my basic template and I'm not sure how to capture both the category in the Cash section and the same category in the Leases section so they will pull through to total all purchases so I can then calculate Depreciation.
Any formula help out there?
Bookmarks