Substitute cell values for array options in a formula|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi, not sure if this is possible, but I'm trying to use the FILTER function to return an array on Sheet1 based on a table "tableAcct" on Sheet2 with a list of bank accounts and associated information. I've got the filter working great, which returns all rows with the Bank Name that I type into Cell H2 (see below), but I'd also like to use checkboxes to have the user specify which columns from the table to return as part of the array. For that I tried nesting that with another FILTER with the {1,0,0,1,0,0,0} array to say only populate Sheet1 with the first and fourth columns. Works great when the {1,0,0,1,0,0,0} is keyed into the formula, but not when I substitute the 1s or 0s with cell references.

I'd like to have a series of 7 form checkboxes, which when checked make cells X1, X2, X3, etc the value 1, and unchecked the value 0. I tried this:

=FILTER(FILTER(tblAcct,$H$2=tblAcct[BankName]),{X1,X2,X3,X4,X5,X6,X7}). Which gives me an error.

When I mouseover each of the X1, X2, X3 it shows the corresponding 0 or 1 in the tooltip.

How can I pull the 1s and 0s from the results of the checkbox without VBA or Macros?

Thanks!