Forum Discussion

amber_l's avatar
amber_l
Copper Contributor
Sep 10, 2021
Solved

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...
  • ky13ao's avatar
    Sep 10, 2021
    F1=textjoin(",",1,if((A:A=D1)*(B:B=E1),C:C,""))

Resources