Match Zipcodes across 2 sheets

Hi,

I have an issue i can't work out. I have two sheets, sheet one with a full list of zipcodes and sheet two with just some. I want to know which zipcodes in sheet two are found in sheet one. Is there a formula for this?

please find attached an example of what i am trying to do.

If anyone could help that would be great!

Cheers.

Try this:

=COUNTIF(Sheet1!B:B,Sheet2!B2)>0

You can do with Power Query as in the attached.

Are you able to step me through how you used Power Query to get the match list. Im stuck on that.

Cheers

Maybe, put this on C2 and ENTERED as ARRAY FORMULA then copied down

=IFERROR(INDEX(Sheet1!$B$2:$B$133,SMALL(IF(COUNTIF($B$2:$B$6,Sheet1!$B$2:$B$133)>0,MATCH(ROW(Sheet1!$B$2:$B$133),ROW(Sheet1!$B$2:$B$133)),""),ROW(A1))),"")+0

Originally Posted by tgpollock

Are you able to step me through how you used Power Query to get the match list. Im stuck on that.

1) Select a cell inside each list of post codes and add to the Data Model by using Power Query -> From Table/Range.
This will give you 2 queries, one full list and one with the small list of post codes.....

Tell me if you get this step done.