I would like to select from a drop down menu in colum A and after selecting
the required text, colums B and C get populated with additional information.