title: Return a third cell value at the location of another cell if two other cells match
body: <p><a href="https://i.stack.imgur.com/WJAS0.png" rel="nofollow noreferrer">https://i.stack.imgur.com/WJAS0.png</a> (Sorry for the link, I don't have enough rep to post an image)</p>
  
  <p>I'm trying to get a formula where if any of the values found in column D (taking into account that some cells have multiple values ie. cell D4) match a value in Column A then return the value of the same row associated with Column D.</p>
  
  <p>For example, in cell D4 the number 786403213972 matches A2 then cell C4 will return 100. </p>