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

Leave a Reply

Your email address will not be published. Required fields are marked *