In your formula, I think you meant D2 instead of E2

"T. Valko" wrote:

Assume your table is in the range A2:B100

Cell D2 = some employee name

Enter this formula in E2 to return the employee's ID number:

=IF(E2="","",VLOOKUP(E2,$A$2:$B$100,2,0))

Biff

"hsg" wrote in message
...
My data contains two columns, first giving employee name, and second
giving
his identity number, which is unique for each employee.There are hundreds
of
employees.

Wherever I want to use employee name in any table, I want the identity
number to appear in next column opposite name,

can someone help?

harsh