vlookup not working

[tsh1586]

I have a workbook that I am trying to return the total from one worksheet tab to another worksheet tab based on the insured name and plan. I have created a formula that returns the plan name based on the criteria so that the plan name matches on both sheets. I have also combined first and last name, then combined the name with the plan on both worksheets so that I can match the name and the plan to return the amount. It is not returning an amount, I either get a zero or a n/a. Help would be greatly appreciated. I am not sure how to get my entire worksheet to attach. What I need to do is match the name and ADP plan name from worksheet ListBill with the name and plan name on the ADP worksheet and return the Total Employee and Employer amount.
formula using =VLOOKUP(P33,ADP!O2:P352,2,FALSE)

Thanks for any help you can provide... If someone can let me know how to attach the worksheet I will do so. I tried everything I knew to do and it still would not show up.
Tammy

 

[Fluff]

You cannot upload files to the site,but there are some add-ins available here that will enable you to add some sample data to a post. https://www.mrexcel.com/forum/about-board/508133-attachments.html

 

[GR00007]

A general comment: matching by name / plan name is problematic - is there any unique ID(s) common in both files that could be used?

 

[tsh1586]

Excel 2013/2016

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
Insured Last Name	Insured First Name	Insured ID	Division	Department	Class	Coverage Type	Coverage Tier	Premium	Volume	Total Premium	Combine Name	Combine	ADP Plan Name	Combine name and plan	Total ADP
BAHNWEG	NICHOLAS J	IT DIV	AD&D	Member only		BAHNWEG,NICHOLAS J
BAHNWEG	NICHOLAS J	IT DIV	LTD	Member only		BAHNWEG,NICHOLAS J
BAHNWEG	NICHOLAS J	IT DIV	LIFE	Member only		BAHNWEG,NICHOLAS J
BAHNWEG	NICHOLAS J	IT DIV	STD	Member only	BAHNWEG,NICHOLAS J
BAILEY	BRYAN K	POLICE	AD&D	Member only		BAILEY,BRYAN K
BAILEY	BRYAN K	POLICE	LTD	Member only		BAILEY,BRYAN K
BAILEY	BRYAN K	POLICE	LIFE	Member only		BAILEY,BRYAN K
BAILEY	BRYAN K	POLICE	STD	Member only	BAILEY,BRYAN K
BEESTING	ALEXANDRA V	PLAN DEP	AD&D	Member only		BEESTING,ALEXANDRA V
BEESTING	ALEXANDRA V	PLAN DEP	LTD	Member only		BEESTING,ALEXANDRA V
BEESTING	ALEXANDRA V	PLAN DEP	LIFE	Member only		BEESTING,ALEXANDRA V
BEESTING	ALEXANDRA V	PLAN DEP	STD	Member only	BEESTING,ALEXANDRA V
BOLICK	JOSHUA L	POLICE	AD&D	Member only		BOLICK,JOSHUA L
BOLICK	JOSHUA L	POLICE	DEOAD	Children Only		BOLICK,JOSHUA L
BOLICK	JOSHUA L	POLICE	DEOAD	Spouse Only		BOLICK,JOSHUA L
BOLICK	JOSHUA L	POLICE	LTD	Member only		BOLICK,JOSHUA L

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]32[/TD]

[TD="align: right"][/TD]

[TD="align: center"]33[/TD]

[TD="align: right"][/TD]
[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 1.40 [/TD]
[TD="align: right"] $ 50,000.00 [/TD]

[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "] AD&DMember only [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]AD&D[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]BAHNWEG,NICHOLAS J-AD&D[/TD]
[TD="align: right"]#N/A[/TD]

[TD="align: center"]34[/TD]

[TD="align: right"][/TD]
[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 25.10 [/TD]
[TD="align: right"] $ 4,303.00 [/TD]

[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "] LTDMember only [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]Long Term Disability[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]BAHNWEG,NICHOLAS J-Long Term Disability[/TD]
[TD="align: right"]#N/A[/TD]

[TD="align: center"]35[/TD]

[TD="align: right"][/TD]
[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 9.10 [/TD]
[TD="align: right"] $ 50,000.00 [/TD]

[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "] LIFEMember only [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]Basic Life[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]BAHNWEG,NICHOLAS J-Basic Life[/TD]
[TD="align: right"]#N/A[/TD]

[TD="align: center"]36[/TD]

[TD="align: right"][/TD]
[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 34.76 [/TD]
[TD="align: right"] $ 993.00 [/TD]
[TD="align: right"] $ 70.36 [/TD]
[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "] STDMember only [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]STD[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]BAHNWEG,NICHOLAS J-STD[/TD]
[TD="align: right"]#N/A[/TD]

[TD="align: center"]37[/TD]

[TD="align: right"][/TD]
[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 1.40 [/TD]
[TD="align: right"] $ 50,000.00 [/TD]

[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "] AD&DMember only [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]AD&D[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]BAILEY,BRYAN K-AD&D[/TD]
[TD="align: right"]#N/A[/TD]

[TD="align: center"]38[/TD]

[TD="align: right"][/TD]
[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 13.25 [/TD]
[TD="align: right"] $ 2,271.00 [/TD]

[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "] LTDMember only [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]Long Term Disability[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]BAILEY,BRYAN K-Long Term Disability[/TD]
[TD="align: right"]#N/A[/TD]

[TD="align: center"]39[/TD]

[TD="align: right"][/TD]
[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 9.10 [/TD]
[TD="align: right"] $ 50,000.00 [/TD]

[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "] LIFEMember only [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]Basic Life[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]BAILEY,BRYAN K-Basic Life[/TD]
[TD="align: right"]#N/A[/TD]

[TD="align: center"]40[/TD]

[TD="align: right"][/TD]
[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 18.38 [/TD]
[TD="align: right"] $ 525.00 [/TD]
[TD="align: right"] $ 42.13 [/TD]
[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "] STDMember only [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]STD[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]BAILEY,BRYAN K-STD[/TD]
[TD="align: right"]#N/A[/TD]

[TD="align: center"]41[/TD]

[TD="align: right"][/TD]
[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 1.40 [/TD]
[TD="align: right"] $ 50,000.00 [/TD]

[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "] AD&DMember only [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]AD&D[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]BEESTING,ALEXANDRA V-AD&D[/TD]
[TD="align: right"]#N/A[/TD]

[TD="align: center"]42[/TD]

[TD="align: right"][/TD]
[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 20.52 [/TD]
[TD="align: right"] $ 3,518.00 [/TD]

[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "] LTDMember only [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]Long Term Disability[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]BEESTING,ALEXANDRA V-Long Term Disability[/TD]
[TD="align: right"]#N/A[/TD]

[TD="align: center"]43[/TD]

[TD="align: right"][/TD]
[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 9.10 [/TD]
[TD="align: right"] $ 50,000.00 [/TD]

[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "] LIFEMember only [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]Basic Life[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]BEESTING,ALEXANDRA V-Basic Life[/TD]
[TD="align: right"]#N/A[/TD]

[TD="align: center"]44[/TD]

[TD="align: right"][/TD]
[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 28.42 [/TD]
[TD="align: right"] $ 812.00 [/TD]
[TD="align: right"] $ 59.44 [/TD]
[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "] STDMember only [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]STD[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]BEESTING,ALEXANDRA V-STD[/TD]
[TD="align: right"]#N/A[/TD]

[TD="align: center"]45[/TD]

[TD="align: right"][/TD]
[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 1.40 [/TD]
[TD="align: right"] $ 50,000.00 [/TD]

[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "] AD&DMember only [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]AD&D[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]BOLICK,JOSHUA L-AD&D[/TD]
[TD="align: right"]#N/A[/TD]

[TD="align: center"]46[/TD]

[TD="align: right"][/TD]
[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 0.54 [/TD]
[TD="align: right"] $ 10,000.00 [/TD]

[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "] DEOADChildren Only [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]Child AD&D[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]BOLICK,JOSHUA L-Child AD&D[/TD]
[TD="align: right"]#N/A[/TD]

[TD="align: center"]47[/TD]

[TD="align: right"][/TD]
[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 0.29 [/TD]
[TD="align: right"] $ 10,000.00 [/TD]

[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "] DEOADSpouse Only [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]Spouse AD&D[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]BOLICK,JOSHUA L-Spouse AD&D[/TD]
[TD="align: right"]#N/A[/TD]

[TD="align: center"]48[/TD]

[TD="align: right"][/TD]
[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 1.00 [/TD]

[TD="align: right"] $ 11.38 [/TD]
[TD="align: right"] $ 1,950.00 [/TD]

[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "] LTDMember only [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]Long Term Disability[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "]BOLICK,JOSHUA L-Long Term Disability[/TD]
[TD="align: right"]#N/A[/TD]

</tbody>

ListBill​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M33[/TH]
[TD="align: left"]=A33&","&B33[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N33[/TH]
[TD="align: left"]=G33&H33[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]O33[/TH]
[TD="align: left"]=VLOOKUP(N33,Vlookup!$C$2:$D$14,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]P33[/TH]
[TD="align: left"]=M33&"-"&O33[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Q33[/TH]
[TD="align: left"]=VLOOKUP(P33,ADP!O2:P352,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M34[/TH]
[TD="align: left"]=A34&","&B34[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N34[/TH]
[TD="align: left"]=G34&H34[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]O34[/TH]
[TD="align: left"]=VLOOKUP(N34,Vlookup!$C$2:$D$14,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]P34[/TH]
[TD="align: left"]=M34&"-"&O34[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Q34[/TH]
[TD="align: left"]=VLOOKUP(P34,ADP!O3:P353,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M35[/TH]
[TD="align: left"]=A35&","&B35[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N35[/TH]
[TD="align: left"]=G35&H35[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]O35[/TH]
[TD="align: left"]=VLOOKUP(N35,Vlookup!$C$2:$D$14,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]P35[/TH]
[TD="align: left"]=M35&"-"&O35[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Q35[/TH]
[TD="align: left"]=VLOOKUP(P35,ADP!O4:P354,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M36[/TH]
[TD="align: left"]=A36&","&B36[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N36[/TH]
[TD="align: left"]=G36&H36[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]O36[/TH]
[TD="align: left"]=VLOOKUP(N36,Vlookup!$C$2:$D$14,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]P36[/TH]
[TD="align: left"]=M36&"-"&O36[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Q36[/TH]
[TD="align: left"]=VLOOKUP(P36,ADP!O5:P355,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M37[/TH]
[TD="align: left"]=A37&","&B37[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N37[/TH]
[TD="align: left"]=G37&H37[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]O37[/TH]
[TD="align: left"]=VLOOKUP(N37,Vlookup!$C$2:$D$14,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]P37[/TH]
[TD="align: left"]=M37&"-"&O37[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Q37[/TH]
[TD="align: left"]=VLOOKUP(P37,ADP!O6:P356,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M38[/TH]
[TD="align: left"]=A38&","&B38[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N38[/TH]
[TD="align: left"]=G38&H38[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]O38[/TH]
[TD="align: left"]=VLOOKUP(N38,Vlookup!$C$2:$D$14,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]P38[/TH]
[TD="align: left"]=M38&"-"&O38[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Q38[/TH]
[TD="align: left"]=VLOOKUP(P38,ADP!O7:P357,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M39[/TH]
[TD="align: left"]=A39&","&B39[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N39[/TH]
[TD="align: left"]=G39&H39[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]O39[/TH]
[TD="align: left"]=VLOOKUP(N39,Vlookup!$C$2:$D$14,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]P39[/TH]
[TD="align: left"]=M39&"-"&O39[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Q39[/TH]
[TD="align: left"]=VLOOKUP(P39,ADP!O8:P358,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M40[/TH]
[TD="align: left"]=A40&","&B40[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N40[/TH]
[TD="align: left"]=G40&H40[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]O40[/TH]
[TD="align: left"]=VLOOKUP(N40,Vlookup!$C$2:$D$14,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]P40[/TH]
[TD="align: left"]=M40&"-"&O40[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Q40[/TH]
[TD="align: left"]=VLOOKUP(P40,ADP!O9:P359,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M41[/TH]
[TD="align: left"]=A41&","&B41[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N41[/TH]
[TD="align: left"]=G41&H41[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]O41[/TH]
[TD="align: left"]=VLOOKUP(N41,Vlookup!$C$2:$D$14,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]P41[/TH]
[TD="align: left"]=M41&"-"&O41[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Q41[/TH]
[TD="align: left"]=VLOOKUP(P41,ADP!O10:P360,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M42[/TH]
[TD="align: left"]=A42&","&B42[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N42[/TH]
[TD="align: left"]=G42&H42[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]O42[/TH]
[TD="align: left"]=VLOOKUP(N42,Vlookup!$C$2:$D$14,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]P42[/TH]
[TD="align: left"]=M42&"-"&O42[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Q42[/TH]
[TD="align: left"]=VLOOKUP(P42,ADP!O11:P361,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M43[/TH]
[TD="align: left"]=A43&","&B43[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N43[/TH]
[TD="align: left"]=G43&H43[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]O43[/TH]
[TD="align: left"]=VLOOKUP(N43,Vlookup!$C$2:$D$14,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]P43[/TH]
[TD="align: left"]=M43&"-"&O43[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Q43[/TH]
[TD="align: left"]=VLOOKUP(P43,ADP!O12:P362,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M44[/TH]
[TD="align: left"]=A44&","&B44[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N44[/TH]
[TD="align: left"]=G44&H44[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]O44[/TH]
[TD="align: left"]=VLOOKUP(N44,Vlookup!$C$2:$D$14,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]P44[/TH]
[TD="align: left"]=M44&"-"&O44[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Q44[/TH]
[TD="align: left"]=VLOOKUP(P44,ADP!O13:P363,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M45[/TH]
[TD="align: left"]=A45&","&B45[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N45[/TH]
[TD="align: left"]=G45&H45[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]O45[/TH]
[TD="align: left"]=VLOOKUP(N45,Vlookup!$C$2:$D$14,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]P45[/TH]
[TD="align: left"]=M45&"-"&O45[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Q45[/TH]
[TD="align: left"]=VLOOKUP(P45,ADP!O14:P364,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M46[/TH]
[TD="align: left"]=A46&","&B46[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N46[/TH]
[TD="align: left"]=G46&H46[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]O46[/TH]
[TD="align: left"]=VLOOKUP(N46,Vlookup!$C$2:$D$14,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]P46[/TH]
[TD="align: left"]=M46&"-"&O46[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Q46[/TH]
[TD="align: left"]=VLOOKUP(P46,ADP!O15:P365,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M47[/TH]
[TD="align: left"]=A47&","&B47[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N47[/TH]
[TD="align: left"]=G47&H47[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]O47[/TH]
[TD="align: left"]=VLOOKUP(N47,Vlookup!$C$2:$D$14,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]P47[/TH]
[TD="align: left"]=M47&"-"&O47[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Q47[/TH]
[TD="align: left"]=VLOOKUP(P47,ADP!O16:P366,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M48[/TH]
[TD="align: left"]=A48&","&B48[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N48[/TH]
[TD="align: left"]=G48&H48[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]O48[/TH]
[TD="align: left"]=VLOOKUP(N48,Vlookup!$C$2:$D$14,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]P48[/TH]
[TD="align: left"]=M48&"-"&O48[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Q48[/TH]
[TD="align: left"]=VLOOKUP(P48,ADP!O17:P367,2,FALSE)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[tsh1586]

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	NAME	EMPLOYEE STATUS	T	PLAN TYPE	PROVIDER	PLAN NAME	ELIGIBILITY GROUP	PLAN START DATE	COVERAGE LEVEL VALUE	COVERAGE LEVEL AMOUNT	EMPLOYEE COST	EMPLOYEE COST PERIOD	EMPLOYER COST	EMPLOYER COST PERIOD	Combine Name and plan	TOTAL EMPLOYEE AND EMPLOYER
2	BAHNWEG,NICHOLAS J	Active	IT Division	AD&D	Metropolitan Life Ins Co	AD&D	Enrolled	04/01/2018		$50,000.00	$0.00	Monthly	$1.40	Monthly	BAHNWEG,NICHOLAS J-AD&D	1.40
3	BAHNWEG,NICHOLAS J	Active	IT Division	Employee Life	Metropolitan Life Ins Co	Basic Life	Enrolled	04/01/2018		$50,000.00	$0.00	Monthly	$8.60	Monthly	BAHNWEG,NICHOLAS J-Basic Life	8.60
4	BAHNWEG,NICHOLAS J	Active	IT Division	Long Term Disability	Metropolitan Life Ins Co	Long Term Disability	Enrolled	04/01/2018	60% of earnings up to $7000 Per Month		$0.00	Monthly	$25.10	Monthly	BAHNWEG,NICHOLAS J-Long Term Disability	25.10
5	BAHNWEG,NICHOLAS J	Active	IT Division	Short Term Disability	Metropolitan Life Ins Co	STD	Enrolled	04/01/2018	60% of earnings up to $1500 Per Week		$0.00	Monthly	$34.75	Monthly	BAHNWEG,NICHOLAS J-STD	34.75
6	Bailey, Bryan	Active	Police	AD&D	Metropolitan Life Ins Co	AD&D	Enrolled	04/01/2018		$50,000.00	$0.00	Monthly	$1.40	Monthly	Bailey, Bryan-AD&D	1.40
7	Bailey, Bryan	Active	Police	Employee Life	Metropolitan Life Ins Co	Basic Life	Enrolled	04/01/2018		$50,000.00	$0.00	Monthly	$8.60	Monthly	Bailey, Bryan-Basic Life	8.60
8	Bailey, Bryan	Active	Police	Long Term Disability	Metropolitan Life Ins Co	Long Term Disability	Enrolled	04/01/2018	60% of earnings up to $7000 Per Month		$0.00	Monthly	$13.25	Monthly	Bailey, Bryan-Long Term Disability	13.25
9	Bailey, Bryan	Active	Police	Short Term Disability	Metropolitan Life Ins Co	STD	Enrolled	04/01/2018	60% of earnings up to $1500 Per Week		$0.00	Monthly	$18.34	Monthly	Bailey, Bryan-STD	18.34
10	Beesting, Alexandra	Active	Planning Department	AD&D	Metropolitan Life Ins Co	AD&D	Enrolled	04/01/2018		$50,000.00	$0.00	Monthly	$1.40	Monthly	Beesting, Alexandra-AD&D	1.40
11	Beesting, Alexandra	Active	Planning Department	Employee Life	Metropolitan Life Ins Co	Basic Life	Enrolled	04/01/2018		$50,000.00	$0.00	Monthly	$8.60	Monthly	Beesting, Alexandra-Basic Life	8.60
12	Beesting, Alexandra	Active	Planning Department	Long Term Disability	Metropolitan Life Ins Co	Long Term Disability	Enrolled	04/01/2018	60% of earnings up to $7000 Per Month		$0.00	Monthly	$21.55	Monthly	Beesting, Alexandra-Long Term Disability	21.55
13	Beesting, Alexandra	Active	Planning Department	Short Term Disability	Metropolitan Life Ins Co	STD	Enrolled	04/01/2018	60% of earnings up to $1500 Per Week		$0.00	Monthly	$29.83	Monthly	Beesting, Alexandra-STD	29.83
14	Bolick, Joshua L	Active	Police	AD&D	Metropolitan Life Ins Co	AD&D	Enrolled	04/01/2018		$50,000.00	$0.00	Monthly	$1.40	Monthly	Bolick, Joshua L-AD&D	1.40
15	Bolick, Joshua L	Active	Police	Employee Life	Metropolitan Life Ins Co	Basic Life	Enrolled	04/01/2018		$50,000.00	$0.00	Monthly	$8.60	Monthly	Bolick, Joshua L-Basic Life	8.60
16	Bolick, Joshua L	Active	Police	Child AD&D	Metropolitan Life Ins Co	Child AD&D	Enrolled	04/01/2018		$10,000.00	$2.90	Monthly	$0.00	Monthly	Bolick, Joshua L-Child AD&D	2.90
17	Bolick, Joshua L	Active	Police	Child Life	Metropolitan Life Ins Co	Child Life	Enrolled	04/01/2018		$10,000.00	$1.60	Monthly	$0.00	Monthly	Bolick, Joshua L-Child Life	1.60
18	Bolick, Joshua L	Active	Police	Long Term Disability	Metropolitan Life Ins Co	Long Term Disability	Enrolled	04/01/2018	60% of earnings up to $7000 Per Month		$0.00	Monthly	$11.94	Monthly	Bolick, Joshua L-Long Term Disability	11.94
ADP

Cell Formulas
Range	Formula
O2	=A2&"-"&F2
O3	=A3&"-"&F3
O4	=A4&"-"&F4
O5	=A5&"-"&F5
O6	=A6&"-"&F6
O7	=A7&"-"&F7
O8	=A8&"-"&F8
O9	=A9&"-"&F9
O10	=A10&"-"&F10
O11	=A11&"-"&F11
O12	=A12&"-"&F12
O13	=A13&"-"&F13
O14	=A14&"-"&F14
O15	=A15&"-"&F15
O16	=A16&"-"&F16
O17	=A17&"-"&F17
O18	=A18&"-"&F18
P2	=M2+K2
P3	=M3+K3
P4	=M4+K4
P5	=M5+K5
P6	=M6+K6
P7	=M7+K7
P8	=M8+K8
P9	=M9+K9
P10	=M10+K10
P11	=M11+K11
P12	=M12+K12
P13	=M13+K13
P14	=M14+K14
P15	=M15+K15
P16	=M16+K16
P17	=M17+K17
P18	=M18+K18

 

[tsh1586]

that is the only criteria that I have that is unique. I created the name and plan combined to create a unique combo.

 

[tsh1586]

thank you posted sample data

 

[Fluff]

The formula in O33 should be
=VLOOKUP(P33,ADP!O$2:P$352,2,FALSE)
and copied down.
But that will not fully work as there are large discrepancies between your two data sets

 

[tsh1586]

The formula in O33 should be
=VLOOKUP(P33,ADP!O$2:P$352,2,FALSE)
and copied down.
But that will not fully work as there are large discrepancies between your two data sets

Corrected the formula but what discrepancies are you seeing?

 

[Fluff]

Things like, you are looking up the value of
BAILEY,BRYAN K-Basic Life
but on the ADP sheet it's
Bailey, Bryan-Basic Life