Cross-References List for Exact Matches

[Barklie]

Hi All,

---

Is there anyway to create a list of only VLOOKUP Values that are exact matches? I'm trying to create a macro that cross references two tables and populates a list of matches. My current code does the job, but its a pain to go through and delete every row that comes back as #N/A. I could add another add in an IF function that deletes rows with #N/A, but it seems inefficient to do so. Here is my current code:

---

Sub SymmetryFinder()
    Sheets.Add After:=ActiveSheet
    Range("A1") = "UI"
    
i = 2
    Do While ActiveSheet.Previous.Range("A" & i) <> ""
        Cells(i, 1) = "=VLOOKUP(" & ActiveSheet.Previous.Range("AJ" & i) & ",[Estimation_Tools_May.xml]ms_tools!$I$2:$W$163,1,FALSE)"
    i = i + 1
    Loop
End Sub

---

Thanks!