Find text in one column, return value in another column

[tammyradencic]

I don't think this should be too hard:
I need to see if the data in column B has the word "TRUE". If it does, then I need the data from that same row from column A put into the same row, column C. So in this example, cell B2 has the word "TRUE" so I need 50 to be put into C2.
Thanks for any help!

Gift Amount	Team Captain	TC Gift
50	TRUE	50
100
25	TRUE	25

<tbody>
</tbody>

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Mike LH]

Hi,

Try this

=IF(B2,A2,"")

or


=IF(B2=TRUE,A2,"")

 

[Smitty]

Welcome to the Board!

How about:

=IF(B2=TRUE,A2,"")

HTH,

 

[tammyradencic]

You're awesome, thanks!