The sheet is set up as such:
A B C D
Employee Amount Employee Employee
Name (A2) Billed (B2) Name (C2) Amount Paid (D2)
What I need to do is Compare the employee name (a2) and amount billed (b2) to employee name (c2) and employee amount paid (b2). The names are sorted alphabetically but in some cases there is someone on the bill that is not paying for the services so there name does not show up on my listing with employees name and employee amount paid. When this occurs it messes my list up so if the names and amounts do not match up; so I have to go through the list of people and find who is the oddity and causing the list not to match. I am trying to find a way to match the name columns so that the employee name on the bill and the employee name from my paid out listing are in the same row. Once I have the names matching I also want to see if amount billed is the same as amount paid out.