data entry problem
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 |
data entry problem
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 |
data entry problem
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 |
data entry problem
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 |
All times are GMT +1. The time now is 08:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com