I have to create a formula for my spreadsheet. I have four columns A - D

Column A & B (forms)
A has a name
B has an edition number

Column C&D (forms)
C has a name
D has an edition number

A&B represent a web location
C&D represent a different storage location

I have to cross reference A&B with C&D to see where my duplicates are.

I did a query in Access but, my boss wants it done only with Vlookup. I have tried to use the following formula =VLOOKUP(A2,$C$7:$D$219,1,FALSE) and it doesn't exactly work. So I what formula should I be using? How can I find my duplicates (has to be done with a Vlookup Formula) and should I be using a combination? Vlookup and IF?

Also, one problem I have had even with the above is that these columns were copy and pasted from two different spreadsheets. I have to retype the same information in the cell in order to get an accurate response. Even though nothing is different? Font, spacing, location, etc. It's all the same.

Thoughts??? PLEASE PLEASE HELP!!!