Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Id instead of names...?
hellow i relly dont know too much about excel... and they ask me to do this:
i have 1 column with ID of employees, like: E01,E02,E03. and each id, has a name asociated, like john, Lucas, David. so this is in one sheet. then i have another sheet where i have some report and i have a space to put de id of the employee and the name... so i want when i put the employee number on this cell. in the name cell the names apears automatically, in base of the id that i put in the previous cell... i can swer this is too much easy... but i'm still very noob. tnks for the help.. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Id instead of names...?
Hi
ID in col A and names in col B of sheet 1 In sheet2 A2 enter ID to lookup and this formula in B2: =VLOOKUP(A2,Sheet1!A2:B100,2) Regards, Per "excel, name, ids, relation" <excel, name, ids, skrev i meddelelsen ... hellow i relly dont know too much about excel... and they ask me to do this: i have 1 column with ID of employees, like: E01,E02,E03. and each id, has a name asociated, like john, Lucas, David. so this is in one sheet. then i have another sheet where i have some report and i have a space to put de id of the employee and the name... so i want when i put the employee number on this cell. in the name cell the names apears automatically, in base of the id that i put in the previous cell... i can swer this is too much easy... but i'm still very noob. tnks for the help.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using the Excel generic worksheet names instead of user-given names in code | Excel Discussion (Misc queries) | |||
MAKE A LIST OF NAMES FROM REPEATED NAMES IN THE SAME WORKSHEET | Excel Discussion (Misc queries) | |||
COPYING FORMULA CONTAINING NAMES/RELATIVE RANGE NAMES | Excel Discussion (Misc queries) | |||
Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) |