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)
Thanks for helping 🙂