Hello!
I have an inventory spreadsheet that I need to merge to my product
sheet. My example: I have a product sheet with thousands of products
on it. My supplier does not offer a spreadsheet with inventory on it.
However, I can download a seperate spreadsheet that has the product
number and amount of inventory only. The two spreadsheets do not have
the same amount of rows and the products do not line up- THAT WOULD BE
TOO EASY- SORT DATA....

I need to be able to insert the inventory spreadsheet to the product
spreadsheet and have it match product number to product number and
line up with the inventory available.

Example

Column A: Product code
Column B: Product code
Column C: Inventory level

I need A to match B (B being the constant) so that C does not change-
If the values do not match it should remain blank.

Can anyone give my direction on this?

Thanks!