I have 2 sheets and I know to use VLOOKUP to cross-reference the sheets and join the data into one sheet.

I am wondering if there is an application for windows, or an online SaaS that allows you to input two excel sheets and it will do the equivalent of VLOOKUP to combine the data into one sheet.

For reference, I am using MS Office 2007. Maybe the newer versions have a wizard-like method of doing VLOOKUP?

  • Do you have a sample of the data you are working with? Is the data in the two sheets similar (same data points, same formatting/order, etc)
    – James
    Jul 9, 2014 at 16:17
  • @James the data is similar. Name, phone, address. However one list is newer than the other and has less entries (20K vs 30K) and I need to pull in the remaining entries from the bigger list without removing the updated entries in the newer list.
    – degenerate
    Jul 9, 2014 at 16:46
  • So to clarify, Data Set (DS) A is smaller and newer and contains some of the same data as DS-B which is older but has more entries. So keep all of DS-A and copy only the entries in DS-B that do not appear in DS-A (as DS-A is newer data)
    – James
    Jul 9, 2014 at 16:57
  • @James yes correct
    – degenerate
    Jul 9, 2014 at 17:26


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.