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