Children + vlookup + other column



I want to find a value of the children according to the value in another colum (also with children).

In this example, I have a parent row (blue) and 5 children rows (grey). The parent row of column "Price" returns the minimum value of the children. Until here, all ok.

I would like he parent row of the column "Colour" to return the value of the child row that matches the value in the parent row of the column "Price". So, in this example, it should be "Red".

I have tried vlookup and index, but I didn't manage.

Could you please help?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!