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 © 2020 vBulletin Solutions Inc. All rights reserved.