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:
Can anybody help me with this as this formula for the moment is returning as if there were no values?