In "W*1" does * represent a wildcard or a literal *?

If it's the former then your formula won't do what you want - even with same-sized ranges - [you can't use wildcards with a comparison operator like =]

What sort of values do you have in D15:D199?