I am trying to get xl to look up a set of postalcodes, compare them with
another set and return a yes/no value.

If your comparison is for an exact match, the VLOOKUP function might suit
your need.