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

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

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

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

You're right. I'm having one of those days!

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

Should be:

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

Biff

"Teethless mama" wrote in message
...
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