VLOOKUP Cross Reference other sheet issue


I am having an issue where my VLOOKUP formula is working for some numbers but not others. I have two inventory sheets - one inventory of Product A with serial numbers that were delivered to satellite locations and then another sheet of the satellite location inventory. Not all Product A at the satellite were sent by us, some were by other vendors. I want to find out with a cross reference which of Product A were provided by us.

This is my current formula:

=VLOOKUP(SerialNumber@row, {Satellite Delivered Product A Inventory Range 1}, 1)

If there is no match, I get a #NO MATCH, which is fine. But not all of the Serial Numbers are being found. Many are finding a match, but not others. I have looked at the format, etc. Cannot figure it out.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!