I have Item Name n one column and Item code in second column in Sheet2.
I would like to create drop down list in Sheet one. View both columns information in drop down list in the sheet1 drop down list and select and write any only one column value.
Example: View Apple 100 in drop down list in sheet one and able to select and write Item code 100 in the cell


Example:


Item Name Item Code
Apple100

Mango101

Orange102

Banana103



Note: My actual Item list is long -say about 50 Items an with code So for easy entry, need search function if possible



I would like to see Item name with code in drop down list and write only the tem code in the cell.


I would like the drop down list without using Code / VBA as I o not know much about VBA



Would any one help me?