automated selection of drop-down value based on a text value in another cell, default should be emtpy drop-down menu
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.