Match + field is checked, check this box

Nate@E

Hey all - having trouble with this formula. I just need a box to be checked if:

If the number id in sheet A is found on sheet B AND the box on sheet B in a second column is checked…then check the box in sheet A

Here's what I have so far - maybe it should be AND(INDEX(?

=IF(INDEX({UCA E#}, [E# or Group]@row, {Affiliate individual}, true), true, false)

Nate@E

This works actually:

=INDEX({Column to return}, MATCH("Matching Value", {Column with value to match}, 0))

Pulled it from SS help documents…go figure lol.

thanks for your help @Michelle Choate 2

Michelle Choate 2

Try this: =IF(AND({UCA E#}, [E# or Group]@row,{Affiliate individual}, true), true, false

Nate@E

Thanks @Michelle Choate 2

I got an invalid data type.. So it doesn't need index? [E# or Group]@row has to look for a match in the whole column of {UCA E#} and then if it finds a match it needs to only check the box if {Affiliate individual} on that same row it found is checked.

Nate@E

This works actually:

=INDEX({Column to return}, MATCH("Matching Value", {Column with value to match}, 0))

Pulled it from SS help documents…go figure lol.

thanks for your help @Michelle Choate 2