Children + vlookup + other column

Federico

Hello

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?

Thanks.

Federico

Nick Korna

Hi @Federico,

You can use INDEX for this:

=INDEX(Colour:Colour, MATCH(Price@row, CHILDREN(Price:Price), 0))

Hope this helps, but if you've any problems/questions then just let us know!