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?

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 EMPLOYEE + SPOUSE 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

From your question, it is unclear that on what part you exactly want a help, but below I've tried to solve it as possible.

According to EEID field value in 'Employee Tab' select the row from 'Plans Tab'. From that row select the formula in 'tier' column and fill it in 'Medical Plan Name' column of 'Employee Tab'.

If same EEID value doesn't exist in any row of 'Plans Tab' then fill 'Medical Plan Name' column as 'NA'.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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