How can I use an IF statement with INDEX/DISTINCT?

Desiree500

Hello,

I am trying to pull distinct information from a different sheet if a box is checked.

Here is my formula to pull in the distinct information:

=IFERROR(INDEX(DISTINCT({Source Sheet Column_Name}), ID@row), "")

Now, I have a checkbox column called AX S2 and I just want the information from the rows that are checked in this column.

So, if the AX S2 column is checked, then pull the information.

Thank you!

Marcodip

Did you try building a report based on this sheet and then filtering by "AS S2 is checked"?

Desiree500

@Marcodip

Yes I did and it's not what I expected in terms of format. I found a workaround for this, thank you for your help!