I have created a very simple workbook to demonstrate what I am asking.
Lets say I have one sheet called 'order numbers' and a second sheet called 'Carriage charge'
On sheet 2 "Carriage charge" you can see in column D i have a blank column in which i want to add the order value from sheet1
However as you can see from sheet 1 "order numbers" there is one order with the same order number 3 times. Therefore when I do my lookup, i would like it to add these 3 orders together so that it displays the total of £110, rather than find the first one and display £30.
hope that makes sense
Lets say I have one sheet called 'order numbers' and a second sheet called 'Carriage charge'
On sheet 2 "Carriage charge" you can see in column D i have a blank column in which i want to add the order value from sheet1
However as you can see from sheet 1 "order numbers" there is one order with the same order number 3 times. Therefore when I do my lookup, i would like it to add these 3 orders together so that it displays the total of £110, rather than find the first one and display £30.
hope that makes sense