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
Please take a look
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
Sir you may ask your questions
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
https://docs.google.com/spreadsheets/d/1Puzdz4eWwGLcOQWYstNg3skFnAcwLfBOsXJCtr0Rets/edit#gid=0
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.