Mapping in Excel

Help
1

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

2

image
image735×375 17.6 KB

Sorry that I’m unable upload attachment

3

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