Hello,
I am trying to automate the entry of certain text in a cell "C3" based on drop down in another cell "N16".
when i select an item from drop down , the formula works and enters text in cell "C3"
But when i again select another item from dropdown the existing text is replaced by new text...