Do you mean

="Move "&C1&" to "&A1

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Byron720" wrote in message
...
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.
The -1 means I'm short one piece and the 1 I'm over one piece.