Analytic Snapshot Question

Hi all -

I'm looking to transfer the value of a respective Contact look-up field created on a custom object to a new custom object via an Analytic Snapshot. I created a Formula field to equal the Contact look-up field value on the "source" object, but while creating a new record for that "source" object, the output was random numbers/letters. Any ideas?