Excel concatenate function with multiple conditions

Question

I have the following in the first 3 columns of my sheet in excel:

Results table. C3 is where I want the concatenation done

I also have the following table:

Now I am trying to use concatenate to retrieve the items from table 69 using the following conditions: Spec = the value in B1 (Yellow in the first photo) Slot = each of the values in column A (A2:A18)

this is the formula I have in C2:

=CONCATENATE(IF(AND(Table69[Spec]=$B$1;Table69[Slot]=A2);Table69[Item];"")& ",")

Can anybody help me with this as this formula for the moment is returning as if there were no values?

Answer 1

Use this :

=TEXTJOIN(", ";TRUE;IF((Table69[Spec]=$B$1)*(Table69[Slot]=A2);Table69[Item];""))