IF Statement For Name Cross Sheet Reference

Brendan Ginns · 07/20/22

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 · 07/20/22

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

Brendan Ginns · 07/21/22

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 · 07/21/22

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

Brendan Ginns · 07/21/22

Hi Amit,

This worked great! thanks!

Answers