IF, LOOKUP & CHECKBOXES

DJJ12 Is your table an Excel table (Microsoft chose such ambiguous terminology), or just a rows-and-column range?  Is your Sheet 1 structured like this one (for superheroes), where your attributes are in column A?  (Although maybe the attributes are not important.)  And is there no text attached to each checkbox?  (For now, ignore the TRUE and FALSE values.)

Did you specify a Cell link for your checkboxes?  (If you do not understand that question at this time, I will explain it later.)

And are you expecting the content of the project sheets to look like this?

I created the latter using the FILTER function.  Does your version of Excel support that function?

Is the number of projects always four?  (If not, does the number change infrequently?)  I won't post my workbook just yet, as I am trying to work out the technique for supporting any number of superheroes/projects.  Do the statements change over time?