If value exists then lookup

[Wigman86]

Hi All

I think this is an easy one but I want to write a formula that says if cell A1 = "TRUE" then lookup cell B1 into Range C1:C5 AND RETURN "TRUE" OR BLANK.

Hope this makes sense.

Thanks in advance.

 

[JonXL]

I don't understand this part:

"...lookup cell B1 into Range C1:C5..."

Can you elaborate on what you want to look up, from where, and in what cell you want the result displayed?

 

[dreid1011]

Perhaps this?

=IF(A1=TRUE,IF(COUNTIF($C$1:$C$5,B1),TRUE,""),"")

If A1 contains the TEXT value of "TRUE", then this:

=IF(A1="TRUE",IF(COUNTIF($C$1:$C$5,B1),"TRUE",""),"")

 

[FDibbins]

Or maybe this...
=if(a1,if(iserror(match(b1,$c$1:$c$5,0)),"",TRUE))