but i would like to search through a list of product codes that have product
quantities next to them.

i would like excel to automatically add together the quantities of matched
product codes.

for example if i had A1:- 20, A2:- 30, A3:- 20, A1:- 35, A3:- 35

then it would summaries the information to read

A1:- 55
A2:- 30
A3:- 55

hope this makes sense.

Many thanks in advance.

fraser