Matching Formula

kmiras

Hello Community, I'm looking for a formula that will lookup and match a name with the same name from another sheet AND if there is a check box checked in a column on that row, it will automatically check the box on my new sheet. See my very simple example. I can give more context to what I'm trying to do if helpful. Thanks in advance for any help!

Paul Newcome

You would use something along the lines of

=INDEX({Reference Sheet Checkbox Column}, MATCH([Member Name]@row, {Reference Sheet Member Name}, 0))

kmiras

Thank you Paul! I was experimenting with INDEX and MATCH but was over-complicating things. Thanks again, Kath

Paul Newcome

Happy to help. 👍️