was looking for a solution and couldn’t find one.
I have a google sheet with expenses I have(each row represents one expense) which I add every month.
in column A its just a text value I copy from the credit-card excel sheets.
in column D I have a drop-down menu with which I assign for each expense it’s category.

many of those expenses repeated every month, and I would like the value in column D for such an expense to automatically be selected (lets say, from a value->drop-down value table I can make), and for other one-time expenses I want to have the default empty drop-down menu I would need to fill in the column D cell for that row.

I’m not sure it can be done using formulas but I hope it can be done using maybe app script or a macro?