Look up value, return a value
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
If Statement
HI tammyradencic,
You are better using an If statement in this case rather than a lookup function
in cell C2 put the following & copy down:
=if(B2="True",A2,"")
Regards
Mark