Hi,

I have a question and tried to find it through the history of the
groups but no avail. The problem is this, please see example of my
data sheet.

Customer Depot Pallets

Customer 1 Town 1 12
Customer 1 Town 2 11
Customer 2 Town 3 12
Customer 2 Town 3 19
Customer 1 Town 1 7

I Need a look up table that can produce results as per below

Customer 1 Town 1 19
Customer 1 Town 2 11
Customer 2 Town 3 31

Thus performing a two reference lookup on Customer, then Depot to
produce a sum of the total pallets under these conditions.

Please can someone out there help me with this problem as its starting
to get annoying and really could do with sorting it.

Many thanks in advance,

Chris