Match and Sort 2 columns

[nataliez]

Hi All, Im new here and have looked through the forums for anything that can help but so far no luck.

I have 2 columns Im trying to match and sort. The first is the complete page listing/export from a website and the second is the export from a different source of only pages with broken links. I have a few other columns in the report with last updated and the name of the person whos responsible etc and I'd like to be able to sort the columns to farm them out to the right people to update.

That seems like its written very complicated but I just want to make sure Im explaining what Im after 100%

There's quite a few thousand web pages in total and only about 600 pages with broken links so Im trying to match the broken links with the corresponding page.

eg
page owner ................web page.....................broken link
john smith...................page 1........................page 3
jane smith...................page 2........................page 7
jill smith......................page 3........................page 52
jimmy smith................page 4........................page 137
kate smith...................page 5........................page 678

Any help is appreciated

[arlu1201]

Its really not clear on what you are trying to accomplish. Maybe you can attach a sample workbook with a before and after page, so we can understand better.

[nataliez]

Thanks very much for looking - dummy workbook attached.

[arlu1201]

Put in C2:
=IF(ISNUMBER(MATCH(A2,B:B,0)),A2,"No broken links")
Copy C2 down to the last row of data in col A

Col C will return the required results
If desired, just cut out col C and paste special as values to overwrite col B.

Then sort all the data on the basis of column B. Since the link starts with "h" and the "no broken links" starts with "n", all the broken links will be up in the column.