| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Retrieving data from another table or array ..
If i have a master table in Worksheet "A", with the following structure :
Factory Month Week %-ageReceipt China Sep Wk36 100% Korea Sep Wk37 50% USA Oct Wk40 20% UK Nov Wk44 10% In another worksheet "B", i have data, records with the additional information like Destination, Order#, OrderDate, Products, Qty Ordered ..... in addition to the information as mentioned in the master table. How can i , for each record in the Worksheet "B" show the %-ageReceipt from the master table in Worksheet "A" ....... i,e. What %-age of the qty can be expected from which factory in which week of the year ?? Pls. help me with the function which can be used to retrieve data from the MASTER TABLE in Worksheet "A" . thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Retrieving data from another table or array ..
Take a look a INDEX and MATCH functions in Excel Help
"sansk_23" wrote: If i have a master table in Worksheet "A", with the following structure : Factory Month Week %-ageReceipt China Sep Wk36 100% Korea Sep Wk37 50% USA Oct Wk40 20% UK Nov Wk44 10% In another worksheet "B", i have data, records with the additional information like Destination, Order#, OrderDate, Products, Qty Ordered ..... in addition to the information as mentioned in the master table. How can i , for each record in the Worksheet "B" show the %-ageReceipt from the master table in Worksheet "A" ....... i,e. What %-age of the qty can be expected from which factory in which week of the year ?? Pls. help me with the function which can be used to retrieve data from the MASTER TABLE in Worksheet "A" . thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Linear Mode
