Return only values that's include true only

Occasional Contributor

Hello guys,
So i've two sheet ( Main , Summary )

In Main sheet i've O column that's have True , False and blanks like :

O5 =True
O6 = False
O7 = " " ( Means Blank )
O8 = False
O9 = " " ( Means Blank )
O10 = " " ( Means Blank )
O11 = " " ( Means Blank )
O12 = True

so i just want in Summary sheet to get only "True" in column O in main sheet and if true give me the J cells

so what i used in Summary sheet in A5 is : =IF(Main!O5,Main!J5,"")

so what i get was :

A5 = give me what i need
A6 = " " ( Means Blank )
A7 = #VALUE!
A8 = " " ( Means Blank )
A9 = #VALUE!
A10 = #VALUE!
A11 = #VALUE!
A12 = give me what i need


So i just need only to get ( give me what i need ) row under row without ( #VALUE! and " " ( Means Blank ) ) how can i get that ? and get rid of ( #VALUE! and " " ( Means Blank ) ) ?

1 Reply

@abdullahmuthanna 

 

That means O7, O9, O10 and O11 are not empty cells but contain some spaces or other invisible characters in them. Try replacing your formula with the following one and see if this works for you...

 

=IF(Main!O5=TRUE;Main!J5;"")