Return a third cell value at the location of another cell if two other cells match
https://i.stack.imgur.com/WJAS0.png (Sorry for the link, I don't have enough rep to post an image)
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.
For example, in cell D4 the number 786403213972 matches A2 then cell C4 will return 100.
Following up on your last question here, hereby a way to do this (beware, it's long and tricky)
Confirm as array formula through Ctrl+Shift+Enter