reconiling spreadsheets

[Dee]

I am looking for the correct formatting to reconcile two spreadsheets. I am
looking to reconcile sales with commission payout. Any suggestions on how to
format the worksheet to reconcile numerous cells in a row?
I have a few books on how-to with excell and have attended many training
sessions but am not finding what I need, so even a point in the right
direction will help. Thanks

 

[Dee]

Dear SMartin,

Thanks so much for your post but what I want is somewhat simpler than all of
that. I am looking at a spreadsheet of what I sold and then I am comparing
it to what I was paid by the company.
I need to know the function/formula I need to look at one spreadsheet and
compare it directly to the payout spreadsheet.
For example, I have recoreded 6 sales of tv's, recorded by customer name,
product sold and commission paid.
I need to take my payout for commissions that the company gives me and check
to see if the sale to John Smith for the 19" tv was recoreded as such and if
the $45 commission I am owed was paid... so I am looking for a function that
compares several cells on a line with several cells on another line on
another spreadsheet or worksheet and will simply return true or false to the
data if it matches or not...
Am I making any sense? and please tell me this is a fairly simple fix...
It will make my home based business run so much faster!! thanks for your help