**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.*