I have to following inventory data:

Pool Part # Final Discrepancies Actions

FG11 286692-001 -1
FG13 286692-001 1 Move 1 to FG11

I need a formula that automatically gives me the comment "Move 1 to FG11"
considering 1 as the number of parts to move in order to correct both
inventories. Please note that there are hundreds of diferent part #'s under
FG11 and FG13. What I need is for Excel to find, everytime there is an
overcount of one part, if there is the same part # somewhere else with a
short count and suggest me to move the part there. The -1 means I'm short one
piece and the 1 I'm over one piece. Sorting doesn't work when handling
hundreds of parts. It's better if I get that comment automatically then sort
that column and work over it.