Using VBA to match

Hello Everybody,

I have a business requirement to come up with a list of conflicting duties for any person who has duties assigned.
I am not able to get the logic to do this on Excel and would need some help.

Tables I have (Inputs):
1) Name and Duty
2) Duty and Conflict

Output required:
1) Name, Duty, Conflict

I have attached a sample of the requirement. It has the input tables and the required output.

Please advice.
Warm regards.

I don't see where is an issue except that when there is several conflicts for a user only the first one is shown.
To avoid the display of error when the user don't exist use:
=IF( ISERROR(VLOOKUP(B2,$F$2:$G$891,2,0)),"",VLOOKUP(B2,$F$2:$G$891,2,0))
Give more details about the wrong result of the solution

Hi PCI,

The conflict should be listed only if the 'conflicting duty' is also a duty for the person.
For eg. in the file VLookup_Method2.xlsx‎ ,
If Ravi has duty "Application developer" alone, then "System Administrator" should not be listed as a conflicting duty.
But If Ravi is assigned both "Application developer" and "System Administrator" as duties, then the solution should indicate that there is a conflict.
And the result should be like this in that case:


Name| Duty | Conflict
Ravi |"Application developer"|"System Administrator"
Ravi |"System Administrator"|"Application developer"

Try and comment

Please Login or Register  to view this content.

PCI,

this works well.
I couldn't understand the logic though.

Thank you so much.

Regards,
Ravi.