VLOOKUP or MATCH - Need Unique Returns on Multiple Finds

FrenchyFri27 

If you have access to REDUCE, this may work for you:

'Dynamic' a dynamic range for your data in columns A and B
=LET(arr, Sheet1!$A$2:$B$10000, FILTER(arr, (TAKE(arr, , 1) <> "") * (TAKE(arr, , -1) <> "")))

'Header' - an array constant
={"WO#", "Extra(s)"}

'Analyze' Lambda - to be called within REDUCE. Filters each unique Work Order, obtains the unique ingredients, strings them together, and stacks.
=LAMBDA(a,v,LET(
    WO, TAKE(Dynamic, , 1),
    ingredients, TAKE(Dynamic, , -1),
    filtered, TEXTJOIN(", ", 1, UNIQUE(FILTER(ingredients, WO = v))),
    VSTACK(a, HSTACK(v, filtered))
))

Sheet level formula:
=REDUCE(Header,UNIQUE(TAKE(Dynamic,,1)),Analyze)