index match inventory list generated from another inventory list

[dmike23]

I have two types of inventory lists, one is a daily usage record that contains in and out of all inventory. I am trying to link my part # inventory cards to the usage record. I have attached a sample.

I use multiple index(match(match formulas for example


=INDEX(Table9,MATCH(1,(Table9[Column3]=$C$2)*(Table9[Column7]='M-0082'!I6)*(Table9[Column5]='M-0082'!J$2)*(I5<>Table9[Column9]),0),5)
for finding Destination on usage record

but with rolling inventory I sometimes have two of the same entries almost exactly
i.e
part# mag card# dest. onhand =/- after user
5/31/17 A-2B/T 2 M-0082 field 180 -20 160 DS
6/1/17 A-2B/T 2 M-0082 shop 160 20 180 DS

where my index match is looking for the After numbers and On hand Numbers and Part # and Card#.
I thought of using lookup but as my usage list grows so will my inventory cards and screws up the inventory card list. I apologize if this is a poor description but any help or advise is greatly appreciated.

[FDibbins]

Hi, welcome to the forum

Your file contains links to another file, and so just shows errors?

[dmike23]

Thank you!

I apologize, I did not check when I to samples. Please check again, everything should be fixed.