Mapping in Excel

Hi

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

Esmond

image

Sorry that I’m unable upload attachment

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