Get field value on pressing enter at cell in excel
I have a list of Item_Code and its Item_Name in Sheet2 of columns A and B. I want that when I enter Item_Code at B2 cell in Sheet1 and then press ENTER. Then Item_Code is replaced by corresponding Item_Name in Sheet1. How can I achieve this.
|