Could you give more info? (layout, what your tables look like, pattern of
Employee ID#?)

With the limited knowledge, I would say take a look at using VLOOKUP to try
and pull the correct employee # info.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Gerald" wrote:

I need a formula to enter employee numbers in a cell automatically in order
to calculate values for them in another cell