# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need to copy a value from one column to another when text in a another column says "win"
Solved by E. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 03/05/2018 - 02:05
Hi there!
User 03/05/2018 - 02:05
HELLO
Excelchat Expert 03/05/2018 - 02:05
Ah yes you're making an example in the google sheet - perfect :)
User 03/05/2018 - 02:06
SO, IF I enter "win" in cell E1 i want the value in F1 to replicate the D1....
User 03/05/2018 - 02:07
should be easy but I am struggling !
Excelchat Expert 03/05/2018 - 02:07
Gotcha. I can help!
Excelchat Expert 03/05/2018 - 02:07
And what would go into D1 if WIN is NOT entered in column E?
User 03/05/2018 - 02:08
nothing or a value of 0
Excelchat Expert 03/05/2018 - 02:08
Sorry I meant in F1
Excelchat Expert 03/05/2018 - 02:08
the formula goes in column F yes?
Excelchat Expert 03/05/2018 - 02:08
it can be blank OR a zero, whatever you want
User 03/05/2018 - 02:08
it can do? or in e1 - whatever is easiest
Excelchat Expert 03/05/2018 - 02:09
Check that out and let me know if that's what you're after!
User 03/05/2018 - 02:10
perfect.... whats the formula?
Excelchat Expert 03/05/2018 - 02:10
Here it is -
Excelchat Expert 03/05/2018 - 02:10
=if(E1="win",D1,0)
Excelchat Expert 03/05/2018 - 02:10
You can pull that down as well
Excelchat Expert 03/05/2018 - 02:10
for the subsequent rows
User 03/05/2018 - 02:11
thank you so much.... i will be using your help again in the future, where do we donate or sign up?
Excelchat Expert 03/05/2018 - 02:11
it is my pleasure!! That's awesome news. I believe you would just sign up on the Got It website.
Excelchat Expert 03/05/2018 - 02:11
I hope you have a great day and all the best!
User 03/05/2018 - 02:12
which country are you in, just out of interest?
User 03/05/2018 - 02:12
have a great day amigo.....
Excelchat Expert 03/05/2018 - 02:12
I wish I could tell you! They have strict rules about that unfortunately.
Excelchat Expert 03/05/2018 - 02:12
thx again ~
User 03/05/2018 - 02:12
ok, wherever you are - have a good one.
Excelchat Expert 03/05/2018 - 02:12
Thanks!
Excelchat Expert 03/05/2018 - 02:13
You can end the session if you so desire at the top right side of the screen. Or wait out the 12 mins :)

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.