Hi,
I am trying to use a formula to tick a box in Sheet 1 if the following conditions are true:
The email at row (Text Contact) in Sheet 1 matches the Email in the deployment sheet (Email Deployment) and the Event in the deployment sheet (Event Deployment) is equal to "Event Name".
The event column in the deployment sheet is a drop down column, single select. The same email might appear multiple times in the deployment sheet matched to different events.
This is the formula I tried, but it doesn't pull the right data (no error message, just not doing what I want it to do):
=IFERROR(IF(INDEX({Event Deployment}, MATCH([Text Contact]@row , {Email Deployment}, 0)) = "Event Name", 1, ""), "")
Any help with the above would be greatly appreciated.
Thank you
