+ Reply to Thread
Results 1 to 3 of 3

Multi-criteria V Lookup?

  1. #1
    Registered User
    Join Date
    09-14-2020
    Location
    Baltimore, MD
    MS-Off Ver
    16.16.25
    Posts
    2

    Multi-criteria V Lookup?

    Hello Everyone,

    I work on the tech team at a nonprofit that uses Salesforce to capture donations. We have been having problems with the integration recently where not all of the donations listed as successful in our credit card processor make it into our Salesforce instance.

    I need to manually insert several hundred records into the Salesforce database. However, I need to see whether or not the donors are brand new, or have given in the past. If they have given in the past, then an existing account will already exist. The account name will simply be the person's name. I originally tried to delineate between new vs repeat donors by exporting the existing accounts to Excel and using a VLookup. However, that did not do the trick due to duplicate account records. There are many accounts with the same name, e.g. "John Smith at X address" vs "John Smith at Y address".

    Is there a way to create a more complex VLookup, or some other function that will check account name, address, and email addresses for a match or mismatch on all 3 values?

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Multi-criteria V Lookup?

    Hi

    I suppose you must create a column with a key concatenating 'account name' & 'address' & 'email address' as first column in your table. So, you can use VLOOKUP with that key.

  3. #3
    Registered User
    Join Date
    09-14-2020
    Location
    Baltimore, MD
    MS-Off Ver
    16.16.25
    Posts
    2

    Re: Multi-criteria V Lookup?

    Got it, that's a good idea, will try

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multi Criteria Lookup Required
    By CambsBelle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2017, 09:19 AM
  2. Multi criteria lookup with the ''=lookup' formula
    By Ronnet2 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-17-2015, 07:12 AM
  3. Need help with creating a multi-criteria lookup formula
    By mikem24 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-23-2015, 10:52 PM
  4. Multi-Criteria Column Lookup
    By nielsen555 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-23-2015, 12:11 PM
  5. Multi Criteria Lookup
    By jsabo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-27-2013, 02:06 AM
  6. Multi criteria lookup
    By spot1960 in forum Excel General
    Replies: 2
    Last Post: 04-08-2008, 10:33 AM
  7. Multi Criteria lookup
    By epotter in forum Excel General
    Replies: 3
    Last Post: 07-05-2006, 07:35 PM

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