Forum Discussion
EXCEL FORMULA
Hello, I want a formula for the column Parent Name, where i can say, IF "parent ID" = "ID" get me "Name". Thanks
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)