Hi

I have a large list of stockcodes and descriptions that i need to put prices against for a customer. The list contains approx 23,000 lines. Most of the lines are duplicated stock numbers for my customers different sites. Is there a formula i can use that if i put a price against a stock code it will automatically put it against any other matching code on the spreadsheet.

My stockcode is in column B and my prices are in column G.

Any help would be appreciated.

Thanks