PDA

View Full Version : Solved: Check Box Formula

Barryj
10-27-2011, 10:15 PM
I am trying to get this formula to read if check box is true and show nothing if it shows false.

This is the formula

=IF(X2=TRUE,=INDEX,Diagrams!\$C:\$C,MATCH(C2,Diagrams!\$A:\$A,0)+ROW(\$A\$1)-1),"")

Is this able to work as such or should I be looking at another approach.

This part of the formula =INDEX,Diagrams!\$C:\$C,MATCH(C2,Diagrams!\$A:\$A,0)+ROW(\$A\$1)-1)

This part is looking up another sheet and works fine, just trying to add the check box part if possible.

Thanks for any assistance.

mancubus
10-27-2011, 11:48 PM
does your formula contain equal sign "=" before "INDEX"?

Barryj
10-27-2011, 11:54 PM
Yes, I have tried it with and without the = sign but have had no luck.

Rob342
10-28-2011, 12:35 AM
Barryj

Have you assigned x2 to the cell in properties?

Barryj
10-28-2011, 12:41 AM
Yes X2 is the cell linked to the check box.

Aussiebear
10-28-2011, 02:36 AM
In thinking about this issue, the checkbox is an object placed on the worksheet, yet it seems you are checking the cell location.

mancubus
10-28-2011, 05:27 AM
imho, a formula with two = signs must give an error.

you removed and did not work...
can you post the workbook with representative data.

mancubus
10-28-2011, 05:44 AM
am i missing something?

should it be
=INDEX(Diagrams!\$C:\$C,MATCH(C2,Diagrams!\$A:\$A,0)+ROW(\$A\$1)-1)

rather than
=INDEX,Diagrams!\$C:\$C,MATCH(C2,Diagrams!\$A:\$A,0)+ROW(\$A\$1)-1)

Barryj
10-28-2011, 09:20 PM
Ok I have got it mostly working with
=IF(X2=TRUE,INDEX(Diagrams!\$F:\$F,MATCH(B2,Diagrams!\$A:\$A,0)+ROW(\$A\$1)-1)) it displays the result that I want when cell X2 displays TRUE.

But when the check box is not checked it displays false in the cell where I have the formula and the desired result.

As a work around I have custom formatted the cell to white text if it displays false.

Can I add to the formula to show the cell blank when X2 shows FALSE?

mancubus
10-29-2011, 03:31 AM
referring to the formula in post#1
=If(X2=True,INDEX(Diagrams!\$F:\$F,MATCH(B2,Diagrams!\$A:\$A,0)+ROW(\$A\$1)-1),"")

Barryj
10-29-2011, 03:49 AM
Thankyou mancubus, it is now working fine, I will mark this thread as solved.