Excel 2007 : Excel Building a Formula (Vlookup?)

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!!!

Hi and welcome to the board

Maybe posting a sample sheet would help ?

I tried to combine using the Concatenate function but, that made Vlookup in possible. I agree there are other ways to do it. I am trying to learn as much as possible and apprecaite any options My boss has a huge appreciate for Vlookup. I did attach a copy of a similar worksheet.

NVBC - I agree that was not the way to go But what are you going to do when it's requested! In the sample you attached I see that the cell G6 is showing up True and it is should show False? I typed again in the cells it is drawing from as in the past re-typing the text has produced the proper result. Any thoughts on why it's not showing an exact match?

Oops I think I was looking at G4

Sorry it was G6 - G6 shows True
It's in reference to F6 - The table it's drawing from is E. In E5 there is an exact match. So shouldn't G6 be populating as False? I really appreciate all your help