# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

in sheet 1 there are names of patients in column A with their corresponding health insurance company in B and insurance number in C. it there a formula to make the insurance info (automatically appear) in another sheet 2 whenever a patient's in sheet 1 is entered in sheet 2?
Solved by C. W. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 23/09/2018 - 06:31
Hello, welcome to Excel Chat
Excelchat Expert 23/09/2018 - 06:32
I see that you need help with formula to make info appear in one sheet from other sheet. Is my understanding correct?
Excelchat Expert 23/09/2018 - 06:34
Are we connected?
User 23/09/2018 - 06:34
yes
Excelchat Expert 23/09/2018 - 06:34
Is my understanding correct for the question
User 23/09/2018 - 06:35
it would yes
Excelchat Expert 23/09/2018 - 06:35
Great, can you please share the working file so that I can write that formula for you?
User 23/09/2018 - 06:36
hold on
Excelchat Expert 23/09/2018 - 06:36
Excelchat Expert 23/09/2018 - 06:42
Can you please share the workbook
Excelchat Expert 23/09/2018 - 06:46
Are we connected?
User 23/09/2018 - 06:49
there it is
Excelchat Expert 23/09/2018 - 06:50
Thank you, allow me few mins to go through it
Excelchat Expert 23/09/2018 - 06:51
I see that there are columns A,B & C as you mentioned in the question
Excelchat Expert 23/09/2018 - 06:51
Now, do you want information to come from another sheet into sheet 1?
Excelchat Expert 23/09/2018 - 06:51
Or from Sheet 1 to another sheet?
User 23/09/2018 - 06:53
i need the insurance info automatically appear in another sheet 2 whenever a patient's in sheet 1 is entered
Excelchat Expert 23/09/2018 - 06:53
Ok got it, let me create that for you
Excelchat Expert 23/09/2018 - 06:53
User 23/09/2018 - 06:54
the name is entered manually or copy and paste fro antother data sheet
User 23/09/2018 - 06:55
to the name of ashley a for example can be listed on sheet 2 more than once
Excelchat Expert 23/09/2018 - 06:56
Got it, working on it
Excelchat Expert 23/09/2018 - 06:58
Excelchat Expert 23/09/2018 - 06:58
Excelchat Expert 23/09/2018 - 06:59
Is this what you are looking for?
User 23/09/2018 - 07:06
cant replicate it
Excelchat Expert 23/09/2018 - 07:06
Are you trying to do the same in any other excel sheet?
Excelchat Expert 23/09/2018 - 07:07
You need to take care of the references in that sheet
Excelchat Expert 23/09/2018 - 07:07
May be the sheet names or the columns
Excelchat Expert 23/09/2018 - 07:07
Is the formula working in the sheet I shared with you?
User 23/09/2018 - 07:08
im not sure as i can do it
Excelchat Expert 23/09/2018 - 07:09
Can you please share the file in which you are trying to replicate it? I will take a look where the formula is not working
Excelchat Expert 23/09/2018 - 07:14
Are you able to make any progress on the formula? Please let me know if I can help you in this

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.