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.