Have you checked out the VLOOKUP function? You could place the formula
in Source A workbook and look for the matching SKU in Source B. If it
doesn't exist, the formula returns the #N/A error.

http://tinyurl.com/yhurcy


HTH,
JP

On Feb 29, 1:00*pm, McLovin wrote:
I have 2 spreadsheets, each from a different source. *Both spreadsheets
contain a store number, SKU and SKU quantity except one of the spreadsheets
includes SKUs that the other one doesn't . . . *and v/v. *I need to create a
report that compares both spreadsheets and returns the differences. *For
example, if one of the spreadsheets from Source A shows a quantity of 5 for
one SKU, but the other spreadsheet from source B doesn't list that SKU at all
I need it to return a qty of zero or just show a blank. *HELP! *