Try to use the function VALUE in other column to retrieve the emp #. After,
you can use VLOOKUP

--

Rodrigo Ferreira


"Pammy" escreveu na mensagem
...
I have an excel worksheet sent from our Payroll dept from another
application
used for Payroll. The column with emp #'s has a ' in front of the
number('21333). I have tried to edit - find ' but it doesn't find it. I
cannot do a vlookup because of this, I keep getting a ref# error. Any
idea
on how to get rid of the ' in front of the number?