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.

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

However, a VLOOKUP might be what you need.

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

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

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

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

Seems solved

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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

Attached Files

Combined pricing sheet UNS.xlsx (36.1 KB, 9 views)