Trying to create a formula for descriptions to be added if a code is entered

[rthomas]

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.

[gebobs]

Please attach a copy of your sheet, properly sanitized if needed.

However, a VLOOKUP might be what you need.

[rthomas]

Combined pricing sheet UNS.xlsx

This is the sheet, the red box needs to have the description (on description sheet) for the code in C10

thanks

[gebobs]

Sorry, my dichromatic color blindness is a problem. What "red box"?

[rthomas]

Sorry B11 should have been red but I dont think I saved it!

[Pecoflyer]

Cross post without links http://www.excelguru.ca/forums/showt...ed=1#post28186

Seems solved

[gebobs]

Try this. Let me know if you need further help.