fORMULA

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

You can use a vlookup, Martin.
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"martin" <[email protected]> wrote in message
news:[email protected]...
>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
>
>
>

Depending on the layout of your lookup table, you may be able to use an
INDEX/MATCH formula. There are a couple of examples here:

http://www.contextures.com/xlFunctio...ml#IndexMatch2

martin wrote:
> 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
>
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html