contents embed

[Mery]

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

 

[Gav123]

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.

 

[Pete_UK]

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

 

[Pete_UK]

Sorry, should be another bracket at the end:

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

Pete

 

[Mery]

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:

 

[Pete_UK]

Glad to be of help.

Pete