Solved: Check Box Formula
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.