title: TEXTJOIN based on multiple columns and multiple IF conditions
body: <p>I am trying to do a TEXTJOIN based on multiple columns, in this case Column B and D within a selected range (If column A = G9 and column C = H9) while ignoring items in Column D that are not in range G2:G5 (if Column D = an item in range G2:G5). Everything I try seems to result in NA#</p>
  
  <p><a href="https://i.stack.imgur.com/vnDFY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vnDFY.png" alt="enter image description here"></a></p>