I am currently making a household check book. i have a Number Date Column1 Description of Transaction Debit (-) Credit (+) Balance
in column 1 i have set up keywords that i want to designate purchases paychecks food and general. how do i write the v look up formula to transfer the total of the information with balance onto a new sheet?