+ Reply to Thread
Results 1 to 4 of 4

Look at multiple criterias to see if table values match values of other tables

  1. #1
    Registered User
    Join Date
    09-12-2014
    Location
    Paris
    MS-Off Ver
    2013
    Posts
    9

    Look at multiple criterias to see if table values match values of other tables

    Hi there!

    Probably asking a quite dumb question, but:

    I have an Excel folder, with different sheets, listing:
    -Priority accounts for Global Team
    -Priority accounts by country: FR, ES, IT

    I know that Global Team has listed priority accounts that are not part of Priority accounts for countries.
    I would like to be able to see which Priority accounts for Global team are not included in Priority accounts in Country, by comparing, for each sheet:

    Country + Account + Vertical

    However, several issues:
    -I don't know which formula to use. Thought first about vlookup, but don't think it's going to solve my pb.
    -I want to get an error message only if Priority accounts for Global are not in the Country Priority accounts, (and not if Country Priority accounts are not in the Global Priority accounts).
    -I need to take into consideration several sheets (one for FR, one for ES, one for IT, etc...). I didn't do it, but it's probably easier to put all data on one sheet, right?

    I attached a sample example of sheet.

    Does anyone has any insight on how to do this?

    Thanks a lot for the help

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Look at multiple criterias to see if table values match values of other tables

    D2:

    Please Login or Register  to view this content.
    and copy down
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    09-12-2014
    Location
    Paris
    MS-Off Ver
    2013
    Posts
    9

    Re: Look at multiple criterias to see if table values match values of other tables

    Wow, a huge thank you, it works perfectly

  4. #4
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Look at multiple criterias to see if table values match values of other tables

    No problem.

+ 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. Replies: 4
    Last Post: 05-12-2014, 07:10 PM
  2. Extract values from table based on 2 criterias
    By plamenbv in forum Excel General
    Replies: 0
    Last Post: 09-19-2013, 05:09 AM
  3. Replies: 1
    Last Post: 07-31-2013, 04:11 PM
  4. Match two values between two list using two criterias
    By sa02000 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-09-2013, 09:56 AM
  5. Excel 2007 : How to look up values with multiple criterias
    By ralphpammit in forum Excel General
    Replies: 2
    Last Post: 04-03-2012, 11:45 AM

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