Question description:
This user has given permission to use the problem statement for this
blog.
hi, I'd like to search Sheet 2 for a specific name in column x, then copy data in the corresponding row and have it appear in a specific cell in Sheet 1
Solved by V. J. in 32 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
09/08/2018 - 05:29
Hi.. Welcome to Got It Pro
User
09/08/2018 - 05:29
hello
Excelchat Expert
09/08/2018 - 05:30
how can i help you today..?
User
09/08/2018 - 05:32
I have an excel doc with 2 sheets, sheet 1 is a summary and sheet 2 has a bunch of data per person. I'd like to search sheet 2 for a name then copy a cell of that person's data
Excelchat Expert
09/08/2018 - 05:33
Could you upload your file in here? so i can better assist you.
User
09/08/2018 - 05:33
unfortunately not for business privacy
User
09/08/2018 - 05:33
but I can put an example?
Excelchat Expert
09/08/2018 - 05:33
sure..
User
09/08/2018 - 05:37
does that example make sense?
Excelchat Expert
09/08/2018 - 05:37
ok..
Excelchat Expert
09/08/2018 - 05:37
hold on..
User
09/08/2018 - 05:37
ok
Excelchat Expert
09/08/2018 - 05:39
[Uploaded an Excel file]
Excelchat Expert
09/08/2018 - 05:40
please open the file, and let me know..
User
09/08/2018 - 05:41
just tried to open, it says "something went wrong please try again" ?
Excelchat Expert
09/08/2018 - 05:41
[Uploaded an Excel file]
Excelchat Expert
09/08/2018 - 05:41
please try again..
User
09/08/2018 - 05:41
yes I have
User
09/08/2018 - 05:41
keeps saying the same thing
Excelchat Expert
09/08/2018 - 05:41
mm..
Excelchat Expert
09/08/2018 - 05:42
it maybe your company network is preventing download..
Excelchat Expert
09/08/2018 - 05:42
hold on..
User
09/08/2018 - 05:42
ok
User
09/08/2018 - 05:42
that's possible
Excelchat Expert
09/08/2018 - 05:42
I will put the formula on the preview..
User
09/08/2018 - 05:42
thank you
Excelchat Expert
09/08/2018 - 05:43
ok.. it's ready..
User
09/08/2018 - 05:43
wow!
Excelchat Expert
09/08/2018 - 05:44
tt use index match function..
Excelchat Expert
09/08/2018 - 05:44
are you familiar with these functions..??
User
09/08/2018 - 05:44
no I wasn't, I was trying to read through all the options to see which would be most appropriate
Excelchat Expert
09/08/2018 - 05:45
ok..
Excelchat Expert
09/08/2018 - 05:45
I will explain how functions work when you ready..
User
09/08/2018 - 05:45
I'm ready
Excelchat Expert
09/08/2018 - 05:46
I will write on the preview window..
Excelchat Expert
09/08/2018 - 05:52
does it make sense..??
User
09/08/2018 - 05:56
so if I were to copy this to my Excel doc, is it the same as googledoc excel?
Excelchat Expert
09/08/2018 - 05:56
yes..
Excelchat Expert
09/08/2018 - 05:56
what you need is change the area..
User
09/08/2018 - 05:56
the red part you highlighted what is that specific to?
Excelchat Expert
09/08/2018 - 05:57
I just highlight part which is the same..
Excelchat Expert
09/08/2018 - 05:57
it show step by step how formula turn to value..
Excelchat Expert
09/08/2018 - 05:58
red formula turn to red value..
User
09/08/2018 - 05:58
oh I see
Excelchat Expert
09/08/2018 - 05:58
this is how formula works..
Excelchat Expert
09/08/2018 - 05:58
i think you can download this google sheet into excel in your computer..
Excelchat Expert
09/08/2018 - 05:59
it's under File Menu..
Excelchat Expert
09/08/2018 - 05:59
I am not completely sure
Excelchat Expert
09/08/2018 - 06:00
if your company network allows or not..
User
09/08/2018 - 06:00
perfect
User
09/08/2018 - 06:00
thank you very very much
Excelchat Expert
09/08/2018 - 06:00
I am glad to help you out
User
09/08/2018 - 06:00
I believe that's all I need
User
09/08/2018 - 06:01
have a good day
Excelchat Expert
09/08/2018 - 06:01
Thank you for using the service.
Excelchat Expert
09/08/2018 - 06:01
Don't forget to give additional feedback to help us improve this service!
Excelchat Expert
09/08/2018 - 06:01
♥¸.,·´`°³о♥ Have a nice day ♥¸.,·´`
User
09/08/2018 - 06:01
ok
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.