Compare Spreadsheets

I have a workbook in Excel 2007 that is pulling from SQL tables.  I have worksheet A and Worksheet B with some values that are the same and some different.

I want to take and compare and find the difference from Worksheet B to Worksheet A.  Example:

Worksheet A:
CELL   Value
A1         12
A2         13
A3         27

Worksheet B:
CELL     VALUE
A1          12
A2          15
A3          27

So now on worksheet C I would expect to see the difference of the following:

CELL       VALUE
A1           15

I want worksheet C to show what is on Worksheet B but not on Worksheet A.  I am not sure what function to use to get the difference.  I tried VLOOKUP but I want the difference of the two sheets.  What is recommended to accomplish this for a function or formula?

Thanks.
gwlanksAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
tomfarrarConnect With a Mentor Commented:
Is this what you had in mind?
C--Users-E221037-Desktop-EE.xlsx
0
All Courses

From novice to tech pro — start learning today.