# Matching of two conditions with multiple output criteria (SOD-Finance)

1. ## Matching of two conditions with multiple output criteria (SOD-Finance)

20170127_SOD Conflicts.PNG

Dear All,

I am currently working on an internal SOD (Separation of Duties) project. As I am not very versed in Excel I am having problems identifying a way to solve this issue with a smart formula.
Would be wonderful if one of you Excel experts could help.

Issue:

- I have a list with (many individual) users
- Each user has a number of tasks he/she can perform
- These tasks may or may not conflict with each other
- Conflicting tasks are listed in a table (see from picture/Excel expert)

Goal:
- Find a formula, which will identify the conflicting tasks, such that the cell tells me, which tasks is the conflicting one (as listed in the table)

Problem:
- Find appropriate formula that lists the corresponding (conflicting) action on the left
- There are Actions which are conflicting with more than one action:
 Is it possible, to have the formula return i.e. “Action Y” and “Action C” etc.?
 Or is this something I will have to try to solve with Access/not Excel?

2. ## Re: Matching of two conditions with multiple output criteria (SOD-Finance)

A lot will depend on how the data are laid out.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

3. ## Re: Matching of two conditions with multiple output criteria (SOD-Finance)

The issue at hand has been on hold for a while, so I just checked. The solution seems great. I will try it out and report back.
Thank You for the speedy response!

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

#### 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