All solutions COLUMNS Expert Solution – Excel COLUMN Problems

Excel - COLUMN Function Problem - Expert Solution

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.

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc