IF Statement For Name Cross Sheet Reference

Brendan Ginns

Hi i am looking to correct this if statement. IF the name in sheet 1 matches the name in sheet two it will check the box.

=IF({Mailchimp Database Range 1}, =Name@row, "1")

Hollie Green

If({Mailchimp Database Range 1}=Name@row,1,0)

Brendan Ginns

Hi Hollie,

Thanks for your response. However, I am still getting an Invalid Operations Error with this formula. let me know if you have any ideas.

Thanks,

Brendan

Amit Wadhwani

Hi @Brendan Ginns

Can you try this

=IF(INDEX({Mailchimp Database Range 1}, MATCH([Name@row]@row, {Mailchimp Database Range 1}, 0)) = [Name@row]@row, 1, 0)

Regards

Amit Wadhwani, Smartsheet CoE, Ignatiuz Software, Exton, PA

https://www.linkedin.com/in/amitinddr/

Brendan Ginns

Hi Amit,

This worked great! thanks!