Linking information

[Guest]

I have a form where the user picks a name from a list of options. I'd then
to associate that name with an employee identification number for keeping the
identity of the person private in reports and data analysis. Is there a way
to do this in excel?

 

[Guest]

To be more specific. The list is of Physicians and I need the form or
datasheet to automatically look up thier ID number when someone selects their
name. Does this need to be a separate field and how do you get that field to
retrieve the information?

 

[Larry Daugherty]

Right pew, wrong church. You should post Excel issues into Excel
newsgroups.

HTH