Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
contents embed | Excel Worksheet Functions | |||
EMBED | Excel Discussion (Misc queries) | |||
EMBED | Charts and Charting in Excel | |||
Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
Embed a US MAP | Charts and Charting in Excel |