1. Checkbox issue:

U+2610 ☐BALLOT BOX U+2611 ☑ BALLOT BOX WITH CHECK U+2612 ☒ BALLOT BOX WITH X

  1. Calc:
    1. $ to lock rows on which to extend same formula for
    2. Vlookup on multiple rows:
      1. Create a helpful variable =A1&"|"&B1 then use it to lookup from another table or datasheet.