My excel data has 2 columns. Data in my worksheet is like below.
ColumnA ColumnB A | Data of A B | Something C | Some text D | Test Data E | Data of E
I want to know how can I set value of columnB when I input value to columnA. E.g. if I have input new row and input columnA = D then the value of columnB is = "Test Data" automatically, but if my input has never found before it does nothing.