contents embed
 

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

contents embed
 

Hi Mery,

You could try this...

In Sheet2 A1 (the first cell for your automatic Key ID) type


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

And drag down as needed.

Hope this helps.

Gav.


"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

contents embed
 

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

contents embed
 

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 -

contents embed
 

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 -

contents embed
 

Glad to be of help.

Pete

On Apr 28, 4:25*pm, Mery wrote:
Hi Pete_UK

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

Thanks very much again,

Regards,
Mery