Hello,

Am new to all this but this is what am trying to do

Sheet 1 - list of retail products

Sheet 2 -another list of Retail products but they have children
(materials) these are figures percentages required for the Retail
Product

Sheet 3 - this is doing a lookup against the Retail product with the
materials required against them =VLOOKUP(A2,BOM!$A$2:$D$36785,2)

Sheet 1 - Beans on toast

Sheet 2 - Beans on toast - Contain beans 40%
Beans on toast - Contains Toast 55%
Beans on toast - Contains butter 5%

Sheet 3 - Retail Product ING1 ING2 ING3

But if I know there is a second child to the parent it will still show
the first material.
How do I get the vlookup to look and the next material for the retail
product and repeat this process in the next column as there could be
up to 10 items without duplicating the any of the other materials for
that Retail Product

I know this is probably simple but am stuck