I need to look up various types of Depreciation , where the values are in column 105 (Col DL) and the decriptions are in col L
I have tried to use the following formula to add all the various depreciation types in Col 105, but cannot get it to add the values
=IF(A69=(RIGHT(A69,50)),VLOOKUP("*Depreciation*",Sheet1!$L$1512:$DL$1783,105,FALSE))
The various types of depreciation are:
DEPRECIATION-COMPUTER EQUIP
DEPRECIATION Corp Signage
DEPRECIATION-P & M
DEPRECIATION-F & F
DEPRECIATION-OE
your assistance will be most appreciated
I have tried to use the following formula to add all the various depreciation types in Col 105, but cannot get it to add the values
=IF(A69=(RIGHT(A69,50)),VLOOKUP("*Depreciation*",Sheet1!$L$1512:$DL$1783,105,FALSE))
The various types of depreciation are:
DEPRECIATION-COMPUTER EQUIP
DEPRECIATION Corp Signage
DEPRECIATION-P & M
DEPRECIATION-F & F
DEPRECIATION-OE
your assistance will be most appreciated