+ Reply to Thread
Results 1 to 4 of 4

Mail Merge or just Merge Spreadsheet Data

  1. #1
    Registered User
    Join Date
    12-07-2010
    Location
    NY, NY
    MS-Off Ver
    Excel 2007
    Posts
    2

    Mail Merge or just Merge Spreadsheet Data

    Hi all and just want to thank everyone in advance for your help.

    I have two spreadsheets they contain the following:

    1. First Name Last Name Phone Address City State Zip -- About 30,000 entries
    2. Is basically a lead sheet I use that contains fields for all of the above.

    Is there any way that when I am talking to a customer from spreadsheet 1 to have that information merge into spreadsheet 2?

    I can see this question has been somewhat asked in the past but unfortunately I can only follow specific instructions.

    Thanks
    Mooch

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,966

    Re: Mail Merge or just Merge Spreadsheet Data

    I would suggest the use of the VLOOKUP function. This is well documented in Excel Help. Please come back if you need more specific help and include examples from the two sheets.
    Martin

    If my solution has saved you time and/or money, please consider sponsoring my run in the 2020 London Marathon in aid of Cancer Research UK.

    https://uk.virginmoneygiving.com/MartinRice

  3. #3
    Registered User
    Join Date
    12-07-2010
    Location
    NY, NY
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Mail Merge or just Merge Spreadsheet Data

    See that's what I initially thought can you do the vlookup on each row?

  4. #4
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,966

    Re: Mail Merge or just Merge Spreadsheet Data

    Add the formulae to the first row and then copy down to the rows below.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1