Forum Discussion
amber_l
Sep 10, 2021Copper Contributor
return multiple lookup values where two seperate matches occur
Hey all, this one may be a bit tricky and I cant think of the best way to get what I need. Here is my data below Column A = product code Column B = length available Column C = colour availa...
- Sep 10, 2021F1=textjoin(",",1,if((A:A=D1)*(B:B=E1),C:C,""))