I was wondering if one of you could help me out on this:
I have two sheets in a workbook with individuals names and emails. Most individuals are duplicates on both sheets, except sheet 1 has a "Lesson Status" field. I am interested to compare the sheets using their email (unique value), and if they are present on sheet 1 and 2, then put "Completed" in sheet 1's Lesson status field, otherwise, put "Not completed". Any ideas?
Question
fAlCoNNiAn
Hey guys,
I was wondering if one of you could help me out on this:
I have two sheets in a workbook with individuals names and emails. Most individuals are duplicates on both sheets, except sheet 1 has a "Lesson Status" field. I am interested to compare the sheets using their email (unique value), and if they are present on sheet 1 and 2, then put "Completed" in sheet 1's Lesson status field, otherwise, put "Not completed". Any ideas?
Thanks in advance.
Link to comment
Share on other sites
7 answers to this question
Recommended Posts