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

 

[tsh1586]

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

I am aware of those but the ones that match exactly are not working. I wanted to fix the formula first then I was going to repair the names that needed changed.

 

[Fluff]

If they are not working & you changed the formula as I suggested, then I suspect that are not EXACTLY the same.
On the ListBill sheet in an empty cell put
=ADP!O11=P42
Where O11 & P42 are matching values. What does the formula return?

 

[tsh1586]

If they are not working & you changed the formula as I suggested, then I suspect that are not EXACTLY the same.
On the ListBill sheet in an empty cell put
=ADP!O11=P42
Where O11 & P42 are matching values. What does the formula return?

That is what I was just trying and it says that none of them match "False" I am not sure where it is getting off. All I have done on the listbill sheet is combine first and last name then do a lookup to pull the plan name and add those together in the combine name and plan column.

 

[tsh1586]

That is what I was just trying and it says that none of them match "False" I am not sure where it is getting off. All I have done on the listbill sheet is combine first and last name then do a lookup to pull the plan name and add those together in the combine name and plan column.

just checking the name against each other will work so it must be something to do with adding the plan name.
Is there a formula that I can use that will look at the name column and the plan column and compare it to the name and plan on the ADP worksheet and return the value of the rate from the ADP sheet?

 

[Fluff]

If you look at the example you supplied from the ADP sheet.
Some are upper case & some are proper case.
Some have a space after the comma, others don't.
Some have an initial after the name & some don't.
Until you can sort that out across the two sheets you are going to have problems.