Changing the array in a cell dependent on a check box

[brooksc29]

In this problem, I need to alternate the array in a cell where if one is check box is checked it changes the formula for the array in the cell?

I'd like to say in cell DN6

if the box AL is checked in cell CR2, then the array is
=INDEX(ALABS!$AI$2:$AI$181,MATCH(1,IF(ALABS!$R$2:$R$181=$DA6,1,"")),0)

if the box is checked in cell CR3, then the array is
=INDEX(ALABS!$BJ$2:$BJ$181,MATCH(1,IF(ALABS!$AS$2:$AS$181=$DA6,1,"")),0)

thanks for your help wizards!

 

[GK039]

This one you posted before should work. One checkbox linked to CR2 and then an IF function should do the job

i thought about just changing it to IF CR2 is checked, the array is one thing, if it's not it's another.

I entered this formula for that:
=IF($CR$2,INDEX(ALABS!$AI$2:$AI$181,MATCH(1,IF(ALABS!$R$2:$R$181=$DA6,1,"")),INDEX(ALABS!$BJ$2:$BJ$181,MATCH(1,IF(ALABS!$AS$2:$AS$181=$DA6,1,"")))))

and again CR2 being checked works, but if it's not I simply get FALSE.

any help would be greatly appreciated!!

 

[brooksc29]

it still gives me FALSE as a result if CR2 isn't checked.