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


Item Name Item Code




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?