I have the following excel sheet:

untitled.PNG

In column A i will have all my materials. What i am trying to do is create a dropdown menu for each cell in column A containing a list of all the different equipment that i will be using. When i select an item of material i then want the corresponding price and labour rate for that item to be displayed in columns c and f.

Is this possible or am i asking too much from excel.