I recently got hired in a sales position and would like to make sure im getting paid for what I have sold.
I have a worksheet with 3 columns where I keep track of what I have sold, 1 column shows order number, 2nd column shows services I have sold and the other shows the amount I should be paid for services sold. In worksheet 2 my employer shows me there record of what I have sold and what they are paying out for each service. There worksheet is setup pretty much the same way. 3 columns showing order #, services sold and what they are paying for each service.
I would like to match my worksheet to theirs and make sure the amounts match. If they don't match What can it highlight the cell or something that would indicate which orders don't have matching payout amounts, would be nice. How can I set this up what's the best formula to use and how do I set it up? MATCH or VLOOKUP or??