G Gerald Jul 29, 2009 #1 I need a formula to enter employee numbers in a cell automatically in order to calculate values for them in another cell
I need a formula to enter employee numbers in a cell automatically in order to calculate values for them in another cell
L Luke M Jul 29, 2009 #2 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.
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.