In Microsoft Excel, On [Employees] Tab, use a formula (which references [Plans]

Question

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

Explanation / Answer

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.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.