Id instead of names...?

[excel, name, ids, relation]

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

 

[Per Jessen]

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,
(e-mail address removed)> skrev i meddelelsen
news:[email protected]...

 

[Gord Dibben]

Could be that a Data Validation dropdown and VLOOKUP formula(s) may be in
order.

Visit Debra Dalgleish's site for info on VLOOKUP function to pull data based
on value, in your case, ID no.. Note the downloadable sample
workbooks.

http://www.contextures.on.ca/xlFunctions02.html

Also see Debra's site for creating Data Validation dropdown menus for
choosing an ID no. from a list.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP