+ Reply to Thread
Results 1 to 7 of 7

Lookup functionality from a group against a matrix

  1. #1
    Registered User
    Join Date
    01-06-2015
    Location
    Dallas, TX
    MS-Off Ver
    10
    Posts
    35

    Lookup functionality from a group against a matrix

    Please see the attached, ultimately need help with is writing a formula or code that will be able to differentiate profile groups on sheet 1 and return any instances where the matrix (on sheet 2) may indicate an issue exists within a profile. Issues are identified with an 'x' in the matrix. The formula would be entered in column E of sheet 1 and run all the way down the data set.

    A brief example would be:
    Let's say a profile could not have both "Account Inquiry" and "All Miscellaneous Entries". The matrix would show an 'x' in the cells where Account Inquiry and All Miscellaneous Entries cross (if you look at the attachment you will see on sheet 2 an 'x' in cells E21 and W3) which identifies this as a conflict. With that said, if a profile on sheet 1 (Column B) has both Account Inquiry and All Miscellaneous entries listed in Column C, Cell E on Sheet 1 should indicate the issue in some fashion.

    Can anyone help me out???C3 SOD Mapping.xlsx
    Password for the file is just the number 1
    Last edited by sparkyster; 01-06-2015 at 06:04 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Lookup functionality from a group against a matrix

    Your workbook is password protected.
    Last edited by zbor; 01-06-2015 at 06:36 PM.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Lookup functionality from a group against a matrix

    I'm not sure how this file has been created but a) it asks for the password twice, b) it opens in Excel 2007 as "Copy of C3 SOD Mapping.xlsx" rather than just "C3 SOD Mapping.xlsx", and c) my Password Removal Tool says it does not recognise the file format.

    All that said, I'm afraid I have no idea what to do with it now I have it open. Sorry.

    I'll see if anyone else will have a look. Logged a post in the Call in the Cavalry thread in the Water Cooler forum

    Regards, TMS

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Lookup functionality from a group against a matrix

    I suggest that anyone who looks at this file treats it with care. After I had closed the file, it still came up asking for the password. I had to delete the file from my downloads folder to stop it.

    Very strange behaviour.

  5. #5
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Lookup functionality from a group against a matrix

    Maybe this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    01-06-2015
    Location
    Dallas, TX
    MS-Off Ver
    10
    Posts
    35

    Re: Lookup functionality from a group against a matrix

    Sorry about that TMS... it should be a straight forward excel file. There should not be anything unusual about it, but I will remove the password on things for future posts. Thanks for your effort

  7. #7
    Registered User
    Join Date
    01-06-2015
    Location
    Dallas, TX
    MS-Off Ver
    10
    Posts
    35

    Re: Lookup functionality from a group against a matrix

    Thanks for the formula Zbor, but that didn't work, when I plugged that formula in cell E4 the description is AC Community Inquiry'and the formula returned 'All AP Setup and Processing' which is a conflict according to the matrix; however if you look in sheet 1 at the 'Accounting' profile, 'All AP Setup and Processing' is not a capability of the profile so no real conflict exists. Does that make sense?

+ 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: 3
    Last Post: 05-17-2014, 10:32 AM
  2. Checking for unique value in a matrix and group column value assigned
    By Jackio in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 05-16-2014, 03:39 PM
  3. Matrix Lookup
    By M1234 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 08-23-2013, 01:00 AM
  4. [SOLVED] Need help with lookup functionality
    By boothexcel in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 03-29-2013, 10:20 AM
  5. Replies: 9
    Last Post: 04-12-2012, 02:37 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