**Question description:**

*This user has given permission to use the problem statement for this
blog.*

if a value in the same row is found in another column copy it to another column

Solved by S. A. in 27 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

Excelchat Expert
16/04/2018 - 01:51

Hi!

Excelchat Expert
16/04/2018 - 01:51

How are you? By any chance, are you able to provide a sample data set we could work with?

Excelchat Expert
16/04/2018 - 01:51

Thanks

User
16/04/2018 - 01:52

Hi , i am copying the data now

Excelchat Expert
16/04/2018 - 01:53

Alright, please take your time

Excelchat Expert
16/04/2018 - 01:53

thanks

User
16/04/2018 - 01:53

Thanks

User
16/04/2018 - 01:53

Peer Coach 1

Excelchat Expert
16/04/2018 - 01:54

Okay, can you please help me define the following in terms of cell/range references

User
16/04/2018 - 01:54

peer coach column is randamozied

User
16/04/2018 - 01:55

Marci is coaching linda on the same row

Excelchat Expert
16/04/2018 - 01:55

which row is this by the way?

Excelchat Expert
16/04/2018 - 01:55

okay, the highlighted row - row 1

User
16/04/2018 - 01:56

i need a formula that checks column c and when it finds linda it copy marci to E14

User
16/04/2018 - 01:56

i hope that helps

Excelchat Expert
16/04/2018 - 01:56

so check column c for value = Linda Moradzadeh

Excelchat Expert
16/04/2018 - 01:57

if condition is true, then E2 = Marci Piasecki

Excelchat Expert
16/04/2018 - 01:57

is this correct?

User
16/04/2018 - 01:57

yes

User
16/04/2018 - 01:57

not E2

Excelchat Expert
16/04/2018 - 01:58

E14

Excelchat Expert
16/04/2018 - 01:58

sorry to miss that

User
16/04/2018 - 01:58

the cell in E that is next to marci

User
16/04/2018 - 01:58

and do the same for all peer coaches

User
16/04/2018 - 01:59

is that clear

Excelchat Expert
16/04/2018 - 01:59

i'll try building a formula, and please let me know if i got it correctly

Excelchat Expert
16/04/2018 - 01:59

will let you know if I'm done

User
16/04/2018 - 01:59

i need to fill column E

Excelchat Expert
16/04/2018 - 02:01

so for example, just for final clarification - can you tell me what is the expected value for E2?

Excelchat Expert
16/04/2018 - 02:01

and E3

User
16/04/2018 - 02:01

on sec

Excelchat Expert
16/04/2018 - 02:01

okay

User
16/04/2018 - 02:02

ok , let me think :) one sec please

Excelchat Expert
16/04/2018 - 02:02

sure :) no worries

User
16/04/2018 - 02:04

This is it

User
16/04/2018 - 02:04

you got it

Excelchat Expert
16/04/2018 - 02:05

got it

User
16/04/2018 - 02:05

ok , thanks

User
16/04/2018 - 02:05

and so on

Excelchat Expert
16/04/2018 - 02:06

can you see the values in column E?

User
16/04/2018 - 02:06

i am checking

User
16/04/2018 - 02:06

now yes i do

Excelchat Expert
16/04/2018 - 02:07

I hope I got your specifications right

Excelchat Expert
16/04/2018 - 02:07

Otherwise please let me know

User
16/04/2018 - 02:07

ok , i am checkinh

User
16/04/2018 - 02:07

Thanks

User
16/04/2018 - 02:09

it seems working great

User
16/04/2018 - 02:09

i please have another question

Excelchat Expert
16/04/2018 - 02:09

Glad to hear that

Excelchat Expert
16/04/2018 - 02:09

go ahead

Excelchat Expert
16/04/2018 - 02:09

as long as it is of the same nature to your original problem :)

User
16/04/2018 - 02:09

how can i alsoi get the emails of the students in columns e top automatically be attched to the column

Excelchat Expert
16/04/2018 - 02:10

do you have the record of student-email address?

Excelchat Expert
16/04/2018 - 02:11

is it okay if I reposition the unsorted email address in column B?

User
16/04/2018 - 02:11

can i attach the emails of each student before the formula in in E kicks in

User
16/04/2018 - 02:11

yes it just needs to be on the same row as the user

Excelchat Expert
16/04/2018 - 02:12

Please see column G

User
16/04/2018 - 02:12

ok

User
16/04/2018 - 02:13

perfect , i think this is it

User
16/04/2018 - 02:13

That is awesome

Excelchat Expert
16/04/2018 - 02:13

Nice!

User
16/04/2018 - 02:13

Great job !!!

Excelchat Expert
16/04/2018 - 02:14

is it okay to mark this problem as ANSWERED?

User
16/04/2018 - 02:14

I truly appreciate that help

Excelchat Expert
16/04/2018 - 02:14

thank you :) i'm happy to help

Excelchat Expert
16/04/2018 - 02:14

If you don't need anything else, you may hover over the Time Remaining part of the window

User
16/04/2018 - 02:14

That will facilitate a lot of things

Excelchat Expert
16/04/2018 - 02:14

and select End Session :)

User
16/04/2018 - 02:14

sure .Thank you so much again

Excelchat Expert
16/04/2018 - 02:15

Glad to know that

Excelchat Expert
16/04/2018 - 02:15

you're welcome

Excelchat Expert
16/04/2018 - 02:15

Your kind feedback is very much appreciated

User
16/04/2018 - 02:15

can i put that in a macro

User
16/04/2018 - 02:15

sure

User
16/04/2018 - 02:15

will do

User
16/04/2018 - 02:15

u guys are amazing

Excelchat Expert
16/04/2018 - 02:15

Oh I'm sorry macros are out of our service scope

Excelchat Expert
16/04/2018 - 02:16

Thanks a lot! You're amazing too :)

User
16/04/2018 - 02:16

how about a formula that randamozes a column into A b c d groups

User
16/04/2018 - 02:16

instead of 1 2 3 4

User
16/04/2018 - 02:17

i am sorry for my many requests

User
16/04/2018 - 02:17

Thanksssssssssssssssssss

Excelchat Expert
16/04/2018 - 02:17

I am sorry but this conversation is monitored and we are only allowed to cover one problem type per session

Excelchat Expert
16/04/2018 - 02:17

If you like, you can try posting that problem here and I'll be glad to take it on for another session with you :)

User
16/04/2018 - 02:18

sure thanks again

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