Mapping in Excel


Can anyone help me regarding mapping in excel. The first sheet contains email and name while the second sheet contains the email. If the email matches, it should display 1 in Column C while displaying 0 if no matches were found. I’ve tried but seem to be stucked in a loop. Thanks in advance



Sorry that I’m unable upload attachment

Excep Applicayion scope
Read Range activity
-Sheet1----> “”
again read range
for each row
sheet1.item(1) = sheet2.item(2)
then your process