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