Not sure which formula I need. I want to look up where it's marked 'x' and return the value of another cell into a destination cell. (On attachment: from cells marked 1 to 2 and 3 to 4) using the 'X' marked A. Additionally, i would like the formula to return multiple values if there is more than one 'x' in the range' See the cells with the blue square marker. (see attachment)

Thanks!


2018-04-18_21-12-37.jpg