In Microsoft Excel On Employees Tab use a formula which refe

In Microsoft Excel, On [Employees] Tab, use a formula (which references [Plans] tab) to fill [Medical Plan Name] for all records. What is this formula? By looking at the plans tab you can easily see what the plan names are for each EEID. I just need the correct excel formula for it. Thank you.

Employees Tab

Plans Tab

EEID	SSN	First Name	Last name	Date of Hire	EEID \"0\" Padded to 7 characters	Last 4 SSN	Full Name	Eligibility Date	Medical Plan Name
1	141658952	EXAMPLE	RECORD	1/1/13	0000001	8952	EXAMPLE RECORD	4/1/13	MIDGRADE MEDICAL
215	852369147	ANOTHER	EXAMPLE	4/1/13	0000215	9147	ANOTHER EXAMPLE	6/30/13	N/A
6261	142689785	Sally	Smith	2/9/10	0006261	9785	Sally Smith	5/10/10
89898	123456789	John	Jones	1/19/11	0089898	6789	John Jones	4/19/11
222	234567891	Brian	Whoknows	12/10/12	0000222	7891	Brian Whoknows	3/10/13
32323	345678912	Marrisa	White	4/1/13	0032323	8912	Marrisa White	6/30/13
78956	456789123	Michael	Whynot	5/15/13	0078956	9123	Michael Whynot	8/13/13
12345	567891234	Dennis	Anywho	6/14/13	0012345	1234	Dennis Anywho	9/12/13
45456	678945612	David	Tyler	9/21/12	0045456	5612	David Tyler	12/20/12
96267	987654321	Charles	Roberts	9/19/12	0096267	4321	Charles Roberts	12/18/12
515	654321987	Wendy	Burger	6/4/12	0000515	1987	Wendy Burger	9/2/12
85252	321654987	Jennifer	Anything	8/2/12	0085252	4987	Jennifer Anything	10/31/12
95865	741852963	Judith	Johnson	5/8/13	0095865	2963	Judith Johnson	8/6/13

The function is VLOOKUP, i send you a excel file in the following link: https://drive.google.com/file/d/0BwC4d-dIFKtJaTB3c21JQXZxbzA/view?usp=sharing

Coment for more information.

In Microsoft Excel, On [Employees] Tab, use a formula (which references [Plans] tab) to fill [Medical Plan Name] for all records. What is this formula? By looki

In Microsoft Excel On Employees Tab use a formula which refe

Solution

Get Help Now

Submit a Take Down Notice