Maybe I'm not understanding what you need, or you aren't explaining it
properly. I've used VLOOKUP for situations just like you describe, on
worksheets with 16k+ rows. Granted, it's not nearly as efficient as
INDEX/MATCH but it does the job.


--JP

On Feb 29, 2:24*pm, McLovin wrote:
VLOOKUP doesn't work on the scale I need it to. *Tried it. *:-( *



"JP" wrote:
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! *- Hide quoted text -

- Show quoted text -