Hi, new to the forums here but have a question for which I can't seem to find a suitable answer.

I have two sets of data I'd like to compare to one another to find multiple values. Dataset A is several columns long and includes about 5000 customer addresses, with separate columns for address, city, state, and zip code, among other identifiers. I need to cross-reference these addresses with Dataset B, which is one column of about 500 zip codes.

Basically, I'm trying to return the rows of customers whose zip codes do not fall into that list of 500. That is, out of the 5000 customers, I'd like to get a list of the ones who do not have these zip codes. So let's say 100 of them do not have one of the 500 zip codes. How do I isolate the entire rows of data for all 100 of these people? Alternatively, how can I get a list of the 900 who DO match?

I can't seem to find exactly how to use vlookup for to both find multiple zip codes and return multiple customer addresses. I also attempted writing a macro based off stuff I've learned on this forum, but it only returns the first row (that is, one customer per zip code even though each zip code may have 300 customers attached to it). The macro route has been more successful, as I at least got to a point where it was finding one corresponding address. No luck at all with vlookup.

Help?!