Hi,
I need your help to do the following : I have a spreadsheet (extracted from my bank account) with mainly two columns : one is the “Paid to” (say column B), and the other is the amount of the expense (say column C).
My goal is to extract all expenses related to food. So I would like to test column B contents (searching for specific words inside the cell) and if one keyword is found, then copy adjacent C cell to another cell, say the adjacent cell in F column. Logic would be like the following :
IF cell Bx CONTAINS one of the keywords, THEN COPY Cx to Fx
I am not sure if this is possible with functions like FIND and IF ? or should I need VBA macro to achieve this ?
Thanks you for your help.