Conditional Format - Copy a cell instead of "true"

[Colinbonnes]

Hi Folks

I am working on a spreadsheet and am using this formula:

=IF(E2="Purchases","Yes"," ")

As you know if the cell E2 contains the work purchases, this cell will
display the word Yes. I actually want the cell this formula is in (G2) to
display the value that is located in cell F2 instead of Yes. Is this even
possible, i've tried several options but obviously don't have the knowledge
to work this one out myself.

Any help would be greatly appreciated!

 

[T. Valko]

Try it like this:

=IF(E2="Purchases",F2,"")

Notice how I removed the space between the quotes at the end of the formula.

 

[Colinbonnes]

I started with no space at the end and i've changed it in one of my dozens of
attempts to get it to work. Obviously i hadn't tried this solution cos it
worked brilliantly. Wish I'd asked an hour ago.

Thanks for your help

 

[T. Valko]

You're welcome. Thanks for the feedback!