Thread: Get field value on pressing enter at cell in excel
View Single Post
 
Old 01-18-2019, 06:48 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
Why not to enter item code into one cell in sheet1, and get proper item name from Sheet2 in adjacent cell? Using VLookup like Bumba did advice! The formula will be something like:
Code:
=VLOOKUP($B2,Sheet2!$A$2:$B$100,2,0)
Reply With Quote