Ooh can you send me a mailing list too please
(just kidding)
This code should do it, got caught up helping someone else and doing some work (imagine)
I'd suggest having a blank workbook and entering the data into the sheets until you are sure it works.
Name the first sheet "File A" and the second "File B" as you described in your original post. (And paste the data in)
NOTE - it has been assumed that on the File B sheet the id numbers are in column A and addresses are in B. if more columns are involved, the line that mentions cells in the code should be ammended (2 is for B)
press ctrl + F11
goto insert - module and paste this macro in.
Sub Results()
'Dim RowNdx As Long
Dim ids As Range
Dim idplus As Range
Dim Rng As Range
'RowNdx = 1
Sheets("File A").Select
Set ids = Range(Range("a2"), Range("a2").End(xlDown))
Sheets("File B").Select
Set idplus = Range(Range("a2"), Range("a2").End(xlDown))
For Each Rng In idplus
If Application.WorksheetFunction.CountIf(ids, Rng.Value) = 0 Then
Sheets("File B").Range(Cells(Rng.Row, 1), Cells(Rng.Row, 2)) = ""
End If
Next Rng
On Error Resume Next 'In case there are no blank rows
Columns("B").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
On Error GoTo 0
End Sub
close down the vb editor
goto tools macro macros and try running the macro (if you select options you can put a shortcut to the macro but as you will probably be running this just one time its not really worth it)
In the file B sheet there should only be the id's and address details of those that are on the File A sheet.