Parent Child relationship issue: Get parent ID for child

Hi,

it is difficult to describe my issue in the Titel so here is my problem.

I have an excel List with lets say 5 rows + Header and 3 columns

ID	Type	Title
1	Parent	MyParentTitle
2	Child	MyCildTitle1
3	Child	MyChildTitle2
4	Parent	MyParentTitle2
5	Child	MyChildTitle3

What I need is to get the Parent ID for each Child. So the table should look like that:

ID	Type	Title	ParentID
1	Parent	MyParentTitle
2	Child	MyCildTitle1	1
3	Child	MyChildTitle2	1
4	Parent	MyParentTitle2
5	Child	MyChildTitle3	4

A Parent might have 0-n childs. Childs are always listed under the parent.

Any ideas?

Thanks in advance

Originally Posted by AliGW

Will children always be listed on the rows immediately after their parent?

Yes. Childs are always listed after their parent

Assuming that your sample data is in A2:C6, headers in A1:C1. Try this formula in D2, then fill down

=IF(B2="parent","",IF(B1="child",D1,A1))

If both parents are listed above a child then you will get the ID from the second parent.

Originally Posted by AliGW

Ins Deutsche übersetzt:

=WENNFEHLER(WENN(B2="Child";VERWEIS(2;1/(B$2:B2="Parent");A$2:A2);"");"")

You missed a bit in the translation, Ali

works perfect. Thanks