EXCEL FORMULA

[Kunal_Mehta]

Hello,
I want a formula for the column Parent Name, where i can say, IF "parent ID" = "ID" get me "Name".
Thanks

[#2]

Hello 

try to use xlookup for the column Parent Name , for the formula , i suppose that your data is in the top of the sheet and begin with the cells A1
=XLOOKUP(C2;$B$1:$B$4;$A$1:$A$4)