Thank you Marvin for the worksheet provided. I also found another way to do what I needed to do. First I used an isna(matching( formula on both sheets which returned a set of boolean values to show which products existed on one list but not the other. I then sorted alphabetically and by boolean value so that the products that existed on both lists would be in alphabetical order at the top of the page. I then copied the available inventory column from the wholesaler sheet over the same column from my inventory. Then I set the available inventory to 0 for all my products that didn't exist on the wholesaler's sheet.

Note to Marvin:
The reason there were so many N/As in that column was that it has been a while since I updated my inventory, and many products I had have fallen out of stock, and new ones have come into stock.

Thank you all for your help and I hope this thread can be of use to others in the future