Someone please help! I try to match 5 local zip codes to a column that contain local and out of state zip code and return a value "Yes" if it match and/or "No" of not match.

for example, i try to match D32:D65479 to M5:M10:

column M5:M10
9xxxx
9xxxx
9xxxx
9xxxx
9xxxx

Column D32:D65479
xxxx
xxxx
xxxx
xxxx

thanks.