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..