+ Reply to Thread
Results 1 to 3 of 3

Cross ref. emails from small list with a larger list?

  1. #1
    Registered User
    Join Date
    09-27-2007
    Posts
    4

    Cross ref. emails from small list with a larger list?

    I have a large list of emails from costumers that signed up for my newsletter, and I also have a list of emails from customers that bought our product. I've been reading some tutorials, but I can't find an easy way to check the list of ppl who bought the product with the list of people that signed up for the news letter.

    When they sign up for the newsletter the keyword search phrase they used to find us is stored. If I can take the list of emails from people who purchased the product and find them in the newsletter list I will get the keywords that led to a sale. Can someone help me how do this?

    Thanks a bunch

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    Sounds like you need to use the VLOOKUP function to match up your key words with sales.

    Have a look in HELP for this.
    Martin

  3. #3
    Registered User
    Join Date
    09-27-2007
    Posts
    4
    Thank you, I've looked it up and it was exactly what I was looking for.

+ 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