What function or array to use? help please :o)

[Alex]

I didn't know where to ask. It would be easier to attach a worksheet to show
the problem. Please point me in the right direction if someone could please.

1) I have a weekly forcast of mother parts. Weeks are on the top row.
MotherParts on on the left column. MotherParts might not always be in the
same order, and they do repeat, but do not repeat in any order.
2) There are a number of child parts for a mother parts. MotherPartA may
have Xnumber of ChildPartM, and MotherPartB may have Ynumber of ChildPartsN
and Znumber of ChildpartM. Childparts per mother part does not change, it can
be listed in a small table.
3) I'm needing a daily forcast of childparts.

I've tried {sum((range=criteria)*(range=criteria)*(data))} arrays, but
having a difficult time (a) matching the day to the weekly forcast and (b)
multipling by the corrosponding number of child parts.
I've tried in Index(data,match(criteria,rang),match(criteria,range))
function, but it only returns the forcast from the 1st mother part it sees,
and doesn't add together the mulitple mother part forecasts.

Thank you anyone for some direction, rather it be a suggestion for a formula
or somewhere else to ask.

 

[NBVC]

HOW TO GET FURTHER HELP WITH A WORKBOO
For further help with it why not join our forums (shown i
the link below) it's completely free, if you do join you will have th
opportunity to add attachments to your posts so you can add workbooks t
better illustrate your problems and get help directly with them. Also i
you do join please post in this thread (link found below) so that peopl
who have been following or helping with this query can continue to d
so. :

--
NBV

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com