I have a table with month as per below
In another worksheet, a column will display a list (please refer to cell R2:R11 in the snapshot) of part number that matches the selected month and content (that contain partial text).
Very much appreciated to share with me the method. Thanks.
And if you are using O365 then you use FILTER FUNCTION
as shown below in the image
Formula used in cell R2 =FILTER($A$2:$A$15,INDEX(($P$2=$C$1:$N$1)*(LEFT($Q$2,2)=LEFT($C$2:$N$15,2)),,MATCH($P$2,$C$1:$N$1,0)))