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
On Tue, 14 Jul 2009 09:30:01 -0700, excel, name, ids, relation <excel, name,
ids,
wrote:
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..