Check if value in List 2 exist in Range 1 or not

[ceecee88]

Thought it was an easy one but it wasn't ^^", I'm trying to see if value in in Range 1 exist in List 2 or not. If yes return 1 if no return 0 in array (example of expected result in column C). I try COUNTIF, IF, SUMIF, SUMPRODUCT but didn't get the result I want, any suggestion please?

Thank you so much!

 

[davesexcel]

The range needs to be absolute. So when you drag down the formula, the list range stays the same.

=COUNTIF($E$2:$E$16,A2)

 

[ceecee88]

The range needs to be absolute. So when you drag down the formula, the list range stays the same.

=COUNTIF($E$2:$E$16,A2)

Hi, is there a way to return this in array not the drag down formula? I need to plug it into another SUMPRODUCT formula (with multiple conditions). I already got other pieces to work just need this bit to return in array.
Thank you!

 

[Phuoc]

=COUNTIF($E$2:$E$4,A2:A9)

 

[ceecee88]

=COUNTIF($E$2:$E$4,A2:A9)

OMG, can't believe it is just that. Genius thank you so much!