inthestands wrote...
I have two spreadsheets where I need to confirm that the correct price
has
been entered for a customer. The customer has numerous items that he
purchases. These items may be the same for different customers, but
may be
priced differently. T
....

This isn't spreadsheet-specific. If you could charge the same customer
or different customers different prices for the same item (e.g.,
airfares), then you need more identifying information than just
customer ID or item ID. You'd need a price table keyed by transaction
number or customer ID *and* item ID *and* transaction date. Without
sufficient detail to identify every different price, you can't reliably
do what you want to do.