Comparing Data with Excel


I have two Excel sheets, each one contains ID and Quantity.

I want to automate the task of comparing the two quantities together for the same ID.


I’ve tried using VLOOKUP function but what I get is N/A.


I’m sure I’ve used it correctly:

VLOOKUP(<ID cell>,<Full array of both ID and Quantity from the other sheet>,2,FALSE)

Any ideas?

Thanks for helping 🙂

Kind regards,

By: Jacob

8 thoughts on “Comparing Data with Excel

  1. ig

    Thank you for every other wonderful post. Where else may anybody get that type of
    information in such a perfect method of writing? I have a presentation subsequent week,
    and I am on the search for such information.

  2. StacySap

    Thanks for providing like passable materials.

  3. HectorMow


    Very educational, looking forwards to visiting again.

  4. HectorMow


    I appreciate the content on your website. Thank you so much!

  5. HomerRen


    I enjoy reading your internet site. Cheers!


Comments are closed.