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: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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