Link to home
Start Free TrialLog in
Avatar of M. Saad
M. Saad

asked on

Compare value based on 2 conditions from duplicated ( multiple ) values

hello , i wish to have your help for the attached file.
i have table have many columns with large amount of duplicate values.
column A have many duplicate vlaues but the other columns ( B,C,D, etc ) will have different values.
i need to search in the table which contain large data based on values mentioned in the list ( 2 conditions only ) and if found it indicate " match " or " not match" if 2 conditons is not match.
hope its clear
thanks in advance
Compare.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Professor J
Professor J

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 M. Saad
M. Saad

ASKER

thank you very much , this what i need
you are welcome.