Help with Sorting

Hi,

I need some help sorting/querying data, I have a spreadsheet with 4 columns, column A- contains distances from 150-1950, column B- contains all the zip codes of areas within each distance. Column C - contains a master list of zip codes for an entire region and column D-an ID number for an income ranking for each zip code in column C. There are about 340 cell values in columns A&B and 480 for Columns C&D. What I need to do is find the zip codes that match between columns B&C but columns A&D need to stay associated with their respective zip code. Is there a way to do this in Excel? I've tried sorting (makes part of the data disappear) I've tried conditional formatting (shows that they're all related) and I've tried an =OR and a Match formula. Any suggestions?

Thanks

Column A Column B Column C Column D
150 12345 11111 2
150 54321 22222 1
150 77562 54321 10
300 77453 12345 2
300 78654 01234 3
1000 98765 00000 1
1000 99999 77564 4
1000 01253 99999 10
99887 3

Ok so here is the file again I want to figure out which numbers match between columns B &C but each cell value in columns A & D corresponds to its respective cell in B & C respectively, Columns A & B go together and C & D go together but I need to find the matches between B & C. Any ideas?/

Hi,

So I think I understand what you're looking for, but only have one match in the attached spreadsheet. i did it by conditional formatting to orange in column B.
Education.xlsx