Hi. I have engineers that complete mechanical checks. To standardise the terminology I want them to enter a 2 letter code which in turn displays a description in another cell. The codes and descriptions are on another sheet. I can’t attach the file but here are a couple of pics that are colour coded to help.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Populate a cell with a description when a code is entered in another cell
Peter_SSs
MrExcel MVP, Moderator
- Joined
- May 28, 2005
- Messages
- 63,880
- Office Version
- 365
- Platform
- Windows
Welcome to the MrExcel board!
Use Data Validation (on the Data ribbon tab), using the first column of the table on the other sheet, in the cell(s) where you want the 2-letter code entered.
Use VLOOKUP, using the table on the other sheet, to return the full description.
Post back if you need more detailed direction.
(My signature block below has help with posting small sample data)
Use Data Validation (on the Data ribbon tab), using the first column of the table on the other sheet, in the cell(s) where you want the 2-letter code entered.
Use VLOOKUP, using the table on the other sheet, to return the full description.
Post back if you need more detailed direction.
(My signature block below has help with posting small sample data)
Last edited:
Upvote
0
Similar threads
- Solved
