A----------B----------C----------D-----------E----------F
1 CHILD1-----CHILD2----CHILD3
CHILD4-----CHILD5
2------PARENT1------YES--------YES-------YES---------NO--------NO
3------PARENT2-------NO--------NO--------YES---------NO--------NO
4
5 CHILD1-----ITEM-------COST
6 ------------BRICKS------$100
7 ------------TILES--------$50
name cell A5 (contains CHILD1) "refchild1"
then to produce the bill of costs for parent1
PARENT1.....=if(b2=1,offset(refchild1,1,1),"") [returns "bricks"]
.................=if(b2=1,offsetrefchild1,1,2),"") [returns
"$100"]
this may give you some starting ideas...
--
robert111
------------------------------------------------------------------------
robert111's Profile:
http://www.excelforum.com/member.php...o&userid=31996
View this thread:
http://www.excelforum.com/showthread...hreadid=530447