I think I figured it out! I used the formula =SUMIF(Table1[Item],Table2[[#This Row],[Item]],Table1[Quantity Issued]) to determine how many of each item were issued and placed said formula in a new range (chart). Then using the formula =SUM(Table2[[#This Row],[Initial count]],-Table2[[#This Row],[Currently Issued]]) in the Quantity in stock column the list auto-populates any inputs from the Issue log. If you folks have a better way of doing this I'm all ears but this is definitely doing what I was hoping it would.
Bookmarks