You can use a vlookup, Martin.
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com
"martin" wrote in message
...
I need a formula that will take teo seperate cells and lookup a differant
spread sheet to give me a total ie,
zone number of pallets
1 2
then this need to take the information from a preset matrix ie
ZONE NO OF PALLET
1 1= 30
1 2=35
1 3=42 AND ETC
can any one help