Excel - IF Function Problem - Expert Solution

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.

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.