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
Sure, take your time
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
[Uploaded an Excel file]
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
Give me few mins please
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
Please check sheet 2 in the uploaded sheet
Excelchat Expert
23/09/2018 - 06:58
[Uploaded an Excel file]
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.