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