Per, thanks for responding.
Actually, the numeric job code represents the employee, not the store.
For example, at Walmart you might find that a cashier is given the job
code "Cash", but each cashier may be paid differently on a scale. The
numeric number would indicate what pay level each "Cash" was. "Cash" at
job level 29 = $20,000, and "Cash" at level 31 = $23,000.

I'm really trying to do this to learn these functions, and to avoid
cutting and pasting any columns. I'd like to build a function that
would do all the referencing for me.

Thanks for your input. I appreciate it!!