Return values based on ID references in another row

[Janka Asser]

Hi everyone,

I am facing the following problem. I have a dataset with ID, Schoolname and the ID of the sibling.

Example:

ID	Schoolname	Sibling_ID	Sibling_Schoolname
1	A	4
3	B	-
4	B	1
10	C	-

Now, the schoolname of the sibling needs to be inserted into the new column "Sibling_Schoolname". Is there a possibility to get the value of "Schoolname" from the row where the ID matches the Sibling_ID in the other row?
More clearly: In the first row Sibling ID is = 4, so I take a look into the row where ID is = 4 and take the Schoolname = B and insert it into Sibling_Schoolname in row 1.

I hope i explained well enough.
Thank you in advance!

[Joro Kolev]

Check out the user written command -vlookup-, and say whether it is doing what you want to be done.

[Janka Asser]

Thank you! It worked