Hi

Could someone please help with an issue I have concerning arranging variables to achieve one outcome.

I have a products sheet that I need to obtain certain information


Product ID Product Name Parent ID Needed outcome
27 Aromatherapy Boxes 11 Aromatherapy///Aromatherapy Boxes

11 Aromatherapy Root

Somehow I need to be able to get an outcome where a cell obtains parent id and looks it up so product 27 would therefore show 11///27, Aromatherapy///Aromatherapy Boxes.

I then need to associated a number in this case 27 to replace 27 in another spread sheet.

Hope that makes sense.