Collecting a check box

Craig Lemberger

Hi All,

The equation below is one that I have used elsewhere under the same circumstances: trying to mark a box based on another sheet that may have several entries. The index match won't work as it only will take the first entry ignore the next different entry for a particular client.

=IFERROR((INDEX({Annabelle Pruned}, {Client Name (Pruning)}, [Client Name]@row, {Pee Gee Name},"Pee Gee"),1),0)

Annabelle Pruned is a Boolean and Pee Gee Name is a text box.

The error is unparseable.

I am always so grateful for the help I get here. I wish I could reciprocate.

Georgie

Hi @Craig Lemberger,

Looks like you've received an answer to this question on a separate thread here. Let us know if you need any additional help!

Thanks

Georgie

Craig Lemberger

Thank you Georgie. Indeed Kerry helped me and solved my issue.