You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Colinbonnes" wrote in message
...
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" wrote:

Try it like this:

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

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

--
Biff
Microsoft Excel MVP


"Colinbonnes" wrote in message
...
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!