View Single Post
 
Old 01-16-2019, 09:44 AM
anuragrawat123 anuragrawat123 is offline Windows XP Office 2007
Novice
 
Join Date: Jan 2014
Posts: 3
anuragrawat123 is on a distinguished road
Default 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.
Reply With Quote