Pulling two lists into one, and showing duplicates.

I know it's possible to have lists referenced and show an answer, but is it possible to do so with duplicates, and showing said duplicates?

Attached is a file, all I need to do is reference the ID, and show said duplicates and where they are.

I could use something like this:

=IFERROR(INDEX('Jobs List'!$F:$F,MATCH(1,INDEX(('Jobs List'!$B:$B=$AG$3)*('Jobs List'!$B:$B=$AG$3),0),0)),IFERROR(INDEX(Archive!$F:$F,MATCH(1,INDEX((Archive!$B:$B=$AG$3)*(Archive!$B:$B=$AG$3),0),0)),""))

But the problem is it should show only the first duplicate and ignore the rest.

I know it's possible, I just don't have the skills to do so. If someone can help It be appreciated.