# Excel - IF Function Problem - Expert Solution

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

i would like to copy a cell to another cell if it contains a certain word
Solved by V. U. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 23/08/2017 - 03:09
no
Excelchat Expert 23/08/2017 - 03:09
Hello sir
User 23/08/2017 - 03:09
hi
User 23/08/2017 - 03:10
thank you so much
Excelchat Expert 23/08/2017 - 03:10
Could you give some example
User 23/08/2017 - 03:10
can i just type something in the sheet to explain?
Excelchat Expert 23/08/2017 - 03:10
Yes sir
Excelchat Expert 23/08/2017 - 03:11
Ok
Excelchat Expert 23/08/2017 - 03:11
What's next?
Excelchat Expert 23/08/2017 - 03:11
What you need to copy
User 23/08/2017 - 03:12
i would like it to search column B if it contains 1a then copy to D5
Excelchat Expert 23/08/2017 - 03:13
the fotmula is added to the range D5
Excelchat Expert 23/08/2017 - 03:13
User 23/08/2017 - 03:14
awesome
Excelchat Expert 23/08/2017 - 03:14
Thank you sir
User 23/08/2017 - 03:14
thanks
Excelchat Expert 23/08/2017 - 03:15
Please do not forget tot rate the session
Excelchat Expert 23/08/2017 - 03:15
Thank you
User 23/08/2017 - 03:15
ok how do i do that
Excelchat Expert 23/08/2017 - 03:15
When the session closed
User 23/08/2017 - 03:15
ok will do thanks
Excelchat Expert 23/08/2017 - 03:15
There will be the rate
Excelchat Expert 23/08/2017 - 03:16
Thank you too
User 23/08/2017 - 03:16
5 stars for you pal
Excelchat Expert 23/08/2017 - 03:16
Thank you sir
User 23/08/2017 - 03:20
are you still there?
Excelchat Expert 23/08/2017 - 03:20
yes sir
User 23/08/2017 - 03:20
i wasn't clear enough
Excelchat Expert 23/08/2017 - 03:21
What's the problem sir
Excelchat Expert 23/08/2017 - 03:21
I'll give you explanation
Excelchat Expert 23/08/2017 - 03:22
User 23/08/2017 - 03:22
i want the teams to populate like this: if b5:b8=1A then copy to d5 and so on an so on
User 23/08/2017 - 03:22
yes of course
User 23/08/2017 - 03:24
if column b has no 1a or 1b or 2a or 2b then ""
Excelchat Expert 23/08/2017 - 03:24

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.