Hi Pete_UK

Immediately, I did it on my sheet and my work functions perfection!

Thanks very much again,

Regards,
Mery


Korisnik "Pete_UK" napisao je:

Sorry, should be another bracket at the end:

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

Pete

On Apr 28, 4:03 pm, Pete_UK wrote:
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- Hide quoted text -

- Show quoted text -