I have 2 lists, in one list I have a customer num, invoice amt, and some
other data (In columns A, B, C, etc). On other sheet I have a second list
which also contains customer num, Invoice amt, other data. This information
is not always the same on both sheets. I need a formula that will find a
customer from sheet 1, look up the customer num on sheet 2, then compare
their Invoice Amounts.

What I did was to create a vlookup to compare the companies, which returned
the invoice amount, in the next column I added an =IF(B2=C2),"same",
different"

Is there an easier way?

Suggestions?