Hello all,
I am using the following formula that this group was helpful with.
-------| Column A------| Col B-------------| Col C-----------| Col D-----------| Col E
Row 1 | Vendor Code--| Item--------------|Cost Each------| Qty on Hand---| Value on hand
Row 2 | Vend 1---------| Item...