Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Depending on the layout of your lookup table, you may be able to use an
INDEX/MATCH formula. There are a couple of examples he 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |