Comparing Data with Excel

Hello,

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.
    [url=http://juventusdomo.it/come-fare-per-aumentare-la-massa-muscolare/]http://juventusdomo.it/come-fare-per-aumentare-la-massa-muscolare/[/url]

  3. HectorMow

    [url=http://publica-pr.de/arginin-powder/]http://publica-pr.de/arginin-powder/[/url]

    Very educational, looking forwards to visiting again.

  4. HectorMow

    [url=http://ko21.fr/amazon-titan-gel/]http://ko21.fr/amazon-titan-gel/[/url]

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

  5. HomerRen

    [url=http://fr.global-box.net/site-map/]http://fr.global-box.net/[/url]

    [url=http://erectionpills.space/site-map/]http://erectionpills.space/[/url]
    I enjoy reading your internet site. Cheers!

    [url=http://it.t-booster2020.com/]http://it.t-booster2020.com/[/url]

Comments are closed.