Put this formula in A1 of Sheet2:

=IF(B1="","",INDEX(Sheet1!A:A,MATCH(B1,Sheet1!B:B, 0))

Enter a name into B1, and A1 should return the ID for that name.

Hope this helps.

Pete

On Apr 28, 3:44*pm, Mery wrote:
On my first sheet1 there are keys ID names of employees into the column A.
On the second sheet2 I need type in into the column B names of employees,
than column A
needs recognize names of employees and automatic types in keys ID

Please, Mr.Pete_UK helped me early but this situation is vise !

As always I am greatful for your help,

Mery