I have a sheet with a list of email addresses that is being auto-updated (more email addresses being added on a daily basis). I have a second sheet with a list of email addresses that have been contacted (marked TRUE).

I would like to add a column to the first sheet indicating which addresses have been marked as contacted, using the email addresses from the second sheet.

I can accomplish this with VLOOKUP, but since I'll be adding addresses to the second sheet, the range is a growing list.

Is it possible to have a function that checks over the growing list of contacted emails?

1 Answer 1


A formula like this:


copied down in your first sheet may serve.

  • This is right, you can fine tune with A1:A etc Commented Jun 18, 2014 at 8:41
  • I mean, =vlookup(A1,Sheet2!A1:A,2,0) is also possible Commented Jun 19, 2014 at 0:02
  • 1
    This is indeed what I was looking for. I didn't realize that you could set the range to span the entirety of both columns with , Sheet2!A:B. Thank you! Commented Jun 21, 2014 at 3:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.