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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.