copying data from one worksheet to another if data in 2 other cells is exact

[FFFran]

I want to have information from a worksheet with standard information be imported to a worksheet that changes daily if the name values match exactly

For example:
[TABLE="width: 256"]
<tbody>[TR]
[TD="class: xl63, width: 64"]

Blue Cross	John	Adams	Strep
Aetna	Ringo	Starr	Good voice
Medicaid	Paul	McCartney	Song writer
United Behavioral Health	President	Reagan	Deceased

<colgroup><col style="width:48pt" span="4" width="64"> </colgroup><tbody>
[TD="class: xl65, width: 64"]insurance[/TD]
[TD="class: xl65, width: 64"]first name[/TD]
[TD="class: xl65, width: 64"]last name[/TD]
[TD="class: xl65, width: 64"]diagnosis[/TD]

</tbody>

[/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 64"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Thus, on[/TD]
[TD]another worksheet whenever I type the name John
Adams in a cell the insurance and diagnosis cells on the other page will automatically be populated. I would like the original worksheet to be dynamic so that every time I add a new person to the first table it can be searched on the next worksheet. Whenever I update the original worksheet, the second worksheet is updated also.

What type of formula would I need to research?
Any help is appreciated. Sorry for the funky formatting, couldn't get it to stop.
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[jamtay317]

you should check this out
Excel Magic Trick 186 Dynamic Formula Extract Data 2 criteria - YouTube

 

[FFFran]

Thank you jamtay for the link. I have spent hours listening to some of his tutorials. Sometimes it is like hearing Greek. I did listen to this one also.
I did find some help with an index function that works well. Do not remember where I found this so I am sorry for not giving credit.(Also listened to the same guy talk about index and array) The only problem I have with this formula is that I have to manually tell it to do the calculation.(fill the data with the mouse) When I update I get the correct answers but randomly get #N/A answers too. I don't understand why.
Here is the formula I found. It copies from one worksheet to the next one.

Where Chastain Student list is the master list with the information that needs to be extrapolated. The fixed match information is in the same columns on the different worksheets. I place the formula in the first column of the worksheet cell that needs to be completed.

=INDEX('Chastain Student list'!E:E,MATCH(1,('Chastain Student list'!B:B=B1)*('Chastain Student list'!C:C=C1),0))

Any tips on making the whole column do the calculation automatically? Or am I missing something simple?

 

[jamtay317]

ok check you privite message box