Forum Discussion
IF, LOOKUP & CHECKBOXES
Hi All,
I have limited knowledge of Excel and I am wondering if there is a simple solution to my problem or if it is a more complicated fix.
What I am ultimately looking to do is:
Background Info
I have a sheet (sheet 1) with a table listing 7 attributes for professional development.
within each of the attributes are several qualifying criteria statements (each statement in a cell of its own.), in the next 4 columns (for 4 projects) I have check boxes for each statement, where the criteria is met on the project the box shall be ticked etc.
Problem
What I seek to achieve is to have the same table on Sheet 2, (Sheet 3 and 4 for the other projects etc.) where it only displays the statements if the box was checked in sheet 1 otherwise leaving them blank.
(Project 1 displays in sheet 2, Project 2 displays in Sheet 3 and so on.)
any help on this would be massively appreciated.
Kind regards,
David
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?
