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