If you want to return only the item code in the same cell as the dropdown after selection, you will need some vba
Check for sample here:
http://www.contextures.com/excelfiles.html
Under Data Validation, look for 'DV0005 - Data Validation "Columns"'
If you can put the result in a separate cell after selection, then you won't necessarily need VBA. You can combine the tables in Sheet2, use that new column in your Dropdown List, then do an Index/Match in a separate cell to return only the code associated.
Bookmarks