Hi,

I am having great difficulty merging two separate Excel sheets, in both sheets there is only 1 identical Column on each sheet the address field which in one cell would look like, 1 Sample Street. Both sheets contain important information, I need to merge these 2 sheets so I have all the information on one sheet.

I can do this manualy however is very time consuming, Also the problem that I have is Data Sheet 1 has maybe 1000 records and Data Sheet 2 has maybe 700 so I have to sort through and filter.

I have been told this is not possible to do using VLookup.