I have 2 sheets within one excel document, one is the front sheet and the other is a sheet which contains codes and their corresponding descriptions & prices.

I need one cell to automatically change to the description when the code is entered into another box (I have a drop down for all codes).

I already have a formula which is for another cell to show the prices of a code when the code is selected from the drop down box (=SUMIF('LBBD Pricework Rates'!A3:A104,'Subbie Weekly Sheet'!C11,Prices)) I have tried to copy that and change the details accordingly but it wont work.