Link to home
Start Free TrialLog in
Avatar of rutgermons
rutgermons

asked on

two dimensional lookups (vlookup&hlookup)

Folks

See my sample excel sheet

I have data in sheet 1 showing my systems and the relevant activities over a calendar day

My question is , if I have more than 1 activities in one day per system this should be flagged as a conflict in sheet 2

so essentially I have 2 criterias that need to match i.e. system and date but it should only display the value if there are multiple activities

multiple activities are denoted by a  comma separator  i.e  test,bounce (test is 1 activity and bounce is another)

kindly help build such a conflict report
conflict.xlsx
ASKER CERTIFIED SOLUTION
Avatar of [ fanpages ]
[ fanpages ]

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rutgermons
rutgermons

ASKER

both solutions are correct, fanpages did respond first, hence the points allocation

will follow up with a new request for this, i think this will work better with a macro and need this built into a macro