I have a Worksheet containing the format similar to the following ,
Worksheet : "Master"
0001 Item A
0002 Item B
Is there any example to show that when a user input a product code, it will return a description of the product ? I need a VBA code solution, not a lookup function on Excel.