Thanks for all the suggestions - I'm still looking through them.

The one thing I realised that I didn't explain is that the kilo's of
freight and freight charges are for each month of the year, over a
number of years. In effect, I'm looking for a monthly freight total.
The VLOOKUP suggestion would definately work well for a month on it's
own, but when it's over a number of columns, it would get a little
messy (unless I misunderstood). I'd be happy to send/post an example
if that would make it easier to explain. I'll try and do a simplified
example below:

Price per kg of dirt
DIRT JAN FEB MAR APR etc
DirtA: $100 110 105 102
DirtB: $250 244 240 233
DirtC: $30 41 50 23
DirtD: $80 65 76 89


Kgs of dirt required

SITE DIRT JAN FEB MAR APR etc
Site1 DirtA 100 250 140
Site1 DirtC 230 340 340
Site1 DirtD 900 200
Site2 DirtA 340 234 230

TOTAL
FREIGHT 50900 etc etc etc

Like I said, there might be 20 dirt types on 5 sites. The freight in
one month for one type of dirt is consistent for all sites. And yes
Arvi, the figures are stored as numbers, not strings. FYI, these
tables are on the same sheet (not that is makes a real lot of
difference).

Thanks again, and I'll check out if pivot tables would do the job.
i've used them in Access a lot, but not so much in excel...

Regards

Reg